PDA

View Full Version : [SOLVED] python and Excel (2007)/Spreadsheets in general



Nebelhom
March 24th, 2010, 05:54 PM
Where would I find information on how to parse the information contained in spreadsheets with python?

I'm getting a bit confused by the topic of which format spreadsheets are in. Apparently Excel 2007 is a different format (XML) to the previous versions (.BIFF?). When I look for python modules for XML, it is all web-based stuff (sax, dom). can I use those modules for that purpose as well?

Any pointers are greatly appreciated. Ta :D

diesch
March 24th, 2010, 07:31 PM
SAX and DOM are general interfaces to access XML documents, they aren't specific to web-bases software.

http://pypi.python.org/pypi?%3Aaction=search&term=excel lists quite a few Python packages related to Excel

Nebelhom
March 24th, 2010, 07:40 PM
Whoa! that is a long list. thanks for the feedback. I'll sieve through that now ;)

thx for the answer