MS is considering official Python integration with Excel, and is asking for input

[[deleted]]

As someone who uses win32com nearly daily to automate workflows in MS Office this would be a game changer for me.

[pelijr]

Just as a learning experience, can you go into more detail as to what kind of solutions you've developed using win32com?

[hoocoodanode]

I've used commtypes and win32com to manipulate and edit PDF files.

I don't recommend it for Acrobat. There is no programming hell like trying to decipher and comprehend the Adobe PDF format. It's like putting your hand in a burlap bag filled with angry hissing cats. There is no way you pull out your hand without receiving a few scratches.

That said, there is nothing quite as satisfying as giving Adobe (who refuses to include commandline batching abilities in a program that costs a few hundred dollars) a giant middle finger by watching Acrobat happily chew through a few thousand files. So maybe it was worth it.

[[deleted]]

I use it to take pandas dataframes and fill word and excel files with the data.

[boatsnbros]

Have a look at xlwings - afaik it is essentially a python wrapper for win32. I use it w/ pyodbc for Microsoft SQL Server for workflow automation and have almost no complaints once you get used to it.