[Lilug] hacking an excel file

Kewisch, Jorg jorg at bnl.gov
Tue Jan 17 12:54:46 PST 2017


Thanks, Thomas.
There are really so many great python packages out there.
________________________________________
From: Lilug [lilug-bounces at lists.lilug.org] on behalf of N.J. Thomas [njt at ayvali.org]
Sent: Tuesday, January 17, 2017 2:40 PM
To: LILUG Mailing List
Subject: Re: [Lilug] hacking an excel file

* 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've used the Python libraries "openpyxl" and "xlsxwriter"
in my scripts. They're both good.

They were largely used for reading and writing simple Excel
spreadsheets, but xlsxwriter claims to be able to read and write macros,
which the file you posted seems to make heavy use of.

It may or may not work for you, but it's worth checking out.

Thomas
_______________________________________________
Lilug mailing list
Lilug at lists.lilug.org
http://lists.lilug.org/listinfo.cgi/lilug-lilug.org


More information about the Lilug mailing list