[Lilug] hacking an excel file

[Jorg Kewisch]

thanks Thomas, I will give it a try.

Jorg



<shameless advertising> The Brookhaven National Laboratory has on the
next 4 Sundays  open house, a different department each Sunday, mine on
August 6th. visitors over 16 years need valid picture ID. It is free and
you can talk to the scientists. bring your kids. LIE exit 68.
https://www.bnl.gov/stakeholder/summerSundays.php
</shameless advertising>

On 07/10/2017 09:34 PM, N.J. Thomas wrote:
> * 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
> _______________________________________________
> Lilug mailing list
> Lilug at lists.lilug.org
> http://lists.lilug.org/listinfo.cgi/lilug-lilug.org
>