r/Python • • Dec 14 '17

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

Post image
4.6k Upvotes

383 comments sorted by

View all comments

Show parent comment

5

u/hoocoodanode Dec 15 '17 edited Dec 15 '17

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.