Python & OpenOffice Spreadsheets

bobicanprogram icanbob at gmail.com
Wed Nov 25 23:18:29 CET 2009


On Nov 23, 5:49 am, Gerhard Häring <g... at ghaering.de> wrote:
> Is there a *simple* way to read OpenOffice spreadsheets?
>
> Bonus: write them, too?
>
> I mean something like:
>
> doc.cells[0][0] = "foo"
> doc.save("xyz.ods")
>
> >From a quick look, pyodf offers little more than just using a XML parser
>
> directly.
>
> -- Gerhard


OO Calc has an HTML file feature for auto updating fields in a
spreadsheet.

I hacked together something for a talk a few years ago:

http://www.icanprogram.com/hosug

(See Open Office Calc demo section)
While it isn't Python code it should be easy enough to convert to
Python.

bob



More information about the Python-list mailing list