[Tutor] parsing Spreadsheet document

[Emile van Sebille]

On 12/9/2009 10:05 PM Christopher Spears said...
> I want to fill a database with the contents of a spreadsheet.  The spreadsheet was created by OpenOffice and is a .sxc document.  What is the best way to do this?  I think the best approach is to save the spreadsheet as a .csv document and then just parse the file.  Am I on the right track here?

OpenOffice can be scripted with python, and if you're planning on 
pushing the data with python anyway, I think I'd look at writing it as 
an OpenOffice script...

Emile