79821245

Date: 2025-11-16 02:14:57
Score: 0.5
Natty:
Report link

It is a strange habit to delete postings without any reason. Happy to repeat that use of PyWin32 and COM wrapping is a solution. Then you can use the normal EXCEL interface (and object methods) directly like you do in VBA. Of course you need to have an EXCEL installation for this to work.

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.

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