Update excel with python

Question

Hi everyone
I’m trying to update an excel file with python, but when I save it it change format and remove style and formulas,

Haw can I update an specific field keeping format as original?

Answer 1

This page links to a Python module to parse Office Open XML (not tested by me):
http://fileformats.archiveteam.org/wiki/XLSX

Thinking maybe Microsoft finally started documenting (@Highman's right), I found file formats:
https://support.office.com/en-us/article/file-formats-that-are-supported-in-excel-0943ff2c-6014-4e8d-aaea-b83d51d46247?ui=en-US&rs=en-US&ad=US

Sampling the BIFF8 format it got deep fast:
"Understanding the binary format..."
https://msdn.microsoft.com/en-us/library/office/gg615597(v=office.14).aspx
"Structure of BIFF8..."
http://docs.roguewave.com/stingray/11/html/ogug/26-2.html

Automation (even SendKeys, or osascript on Mac) might be better than this.

Answer 2

Later versions of Excel use the Office Open XML File Format. They're basically ZIP archives.
If you're not updating the files directly, are you automating a live spreadsheet by using some library (which one)?

Note: I don't have Windows and I won't be able to continue past what I can test / find somewhere online.
The above is intended to help clarify for others.

Answer 3

the format of MS documents is not open.If csv format is suficient for you use rather it insted of origin xls.

Answer 4

Thanks for answering, however I need the xls format as file contain some formulas I would like to keep, and not sure if xml format can help, will try a shot