79820900

Date: 2025-11-15 14:49:13
Score: 0.5
Natty:
Report link

Well, the detour via pandas may work but seems less than perfect. I would use PyWin32 and COM wrapping. Then you can use the normal EXCEL interface directly.

To support such tasks I wrote an EXCEL wrapper that allows to use the EXCLE API even in a pythonic way i. e. you may call the saveas method of a workbook as SaveAs as defined, as saveas or as save_as. All done automatically. Same should work for the parameters. If you consequently use this, one may even won't notice you are using pure EXCEL API in your Python code. With that you only have the overhead of COM interfacing but not all internal file formattingt logic in openPyXL in Python. I think this has a substantial impact on runtime. However, you need to have an EXCEL installation for this to work.

https://github.com/dornech/utils-msoffice

Reasons:
  • Whitelisted phrase (-1.5): you can use
  • Contains signature (1):
  • Long answer (-0.5):
  • No code block (0.5):
  • Low reputation (1):
Posted by: dornech