PDA

View Full Version : Python and spreadsheets


SCHolland
June 21st, 2009, 08:42 PM
I'm trying to learn some python, and I am wanting to obtain data from a spreadsheet. I've found a good description of how to do this using a google spreadsheet (here (http://code.google.com/apis/spreadsheets/docs/1.0/developers_guide_python.html)). And I think this is helpful for Excel (link (http://www.dev-explorer.com/articles/excel-spreadsheets-and-python)).

But I'm having trouble finding info for an OOo spreadsheet. Anyone know which modules and commands might be useful?

I think I read somewhere that converting a spreadsheet to XML and then obtaining the information from the XML file might be useful for some applications. But I haven't worked with XML at all, and I could have misread something.

If anyone could help me with some tips and suggestions or a website link, then I would greatly appreciate it.

Thank you

Steven

Can+~
June 21st, 2009, 08:58 PM
Opendocument and Docx (microsoft pseudo-standard) are both compressed .xml files, I think you can open them like .zip files.

Found more:
http://www.sutor.com/newsite/blog-open/?p=987

SCHolland
June 22nd, 2009, 12:45 AM
Thanks for the info. I'm following along with the site right now. I haven't gotten to what I was specifically looking for yet, but so far, so good and I'm learning quite a bit.