[Lilug] hacking an excel file

N.J. Thomas njt at ayvali.org
Mon Jul 10 18:34:03 PDT 2017


* Jorg Kewisch <jorg at bnl.gov> [2017-01-12 10:24:13-0500]:
> I am more a python guy and I want to rewrite the functionality in
> python. Is there a way to extract the program from the .xls file?

In the past I have used both "xlsxwriter" and "openpyxl" to parse and
write Excel files.

But that was pure textual data. It looks like you want to pull out
formulas. See the relevant section in the openpyxl docs for more info:

    http://openpyxl.readthedocs.io/en/default/formula.html

Thomas


More information about the Lilug mailing list