Saturday, March 8, 2008
OOOLIB. Python module to create procedural spreadsheets
At the beginning of this year I decided to take control of my expenses. To do so, I wanted to automate this annoying task as much as possible, to be aware of my expenses without spending too much time. I started gathering data from my bank using the Norma43 format, then adding this info to a database and so on. After all this, I needed to create reports, and I thought that OpenOffice spreadsheets could be a great place to store them.
To create your procedural spreadsheets you can use csv(coma separated value) files, but you loose the ability to set format configurations like font color, column width and so on. With the ooolib, you can use Python to to create procedural OpenOffice spreadsheets easily and without pain. It doesn´t support all the format options you have in Calc, but the main ones. Definitely enough for me.