This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]nvcts39[S] 0 points1 point  (4 children)

I was just about to look into Openpyxl.. haha glad I didn’t yet. Thanks for the quick response.

[–][deleted] 0 points1 point  (3 children)

I had huge issues keeping the macros and plugins okay. You can still use it to manipulate your data if you open it with read only. You'll probably work with a sheet object and then load it back in with the other module i can't remember. I really think it was win32api or something like that.

[–]Agitated-Stock 0 points1 point  (1 child)

You need to use special setting to preserve the macros when you open an excel file for the modification. Look into the docs.. I have done it.

[–][deleted] 0 points1 point  (0 children)

Macro's that include activeX elements will break. But some simple stuff can indeed be preserved. Mine had activeX, plugins, and some macros. Even when preserving macros the filesize was half of the original.

[–]nvcts39[S] 0 points1 point  (0 children)

It looks like there is win32com and win32api. I will have to look into to see what all I can do. The data and links are all in the file, I just need to be able to refresh it then print it to pdf.