Joachim Dahl asked me to give an example of using OpenOffice.org spreadsheet formulas from Python. After a bit of digging I found out that it’s rather easy. I’ve added a section to my “OpenOffice.
The two small snippets I wrote two days ago were well received in the Python Usenet group. With the danger of being called a hero I proceded and wrote a proper article about OpenOffice.
UPDATE 2019: It seems that the website containing the library required by the below code is down. As such, it’s not really useful anymore.
There is an easy way to get data from an OpenOffice.