Python + OpenOffice Calc

bobicanprogram icanbob at gmail.com
Wed Mar 31 22:21:16 CEST 2010


On Mar 31, 2:47 am, Tracubik <affdfsdfds... at b.com> wrote:
> Hi all!
> i'm giving away to a friend of mine that have a garage (he repair car) my
> old computer. He will use it essentialy to create estimates of the work
> via an ods file (i've made a simple ods file to be filled with the cost of
> materials and a description of the work).
> He's totally new with computer and have difficult to fill the ods file, so
> i'ld like to create a simple python program that help him to introduce the
> data in to the ods file via a simple gui.
> So what i'm looking for is a way in python to insert data in a particular
> cell of the ods file and possibly to save it and print it when it's full
> filled with data.
>
> the guy is similar to this:
>
> 3 fields: quantity - description of the piece bought - price
>
> a way to add a new "line" if needed (for a new piece entry) similar to the
> "add rule" in evolution
>
> 1 text field for the description of the work + 1 field for the price of
> the work
>
> and off course a way to insert this data in to the ods file via python
>
> Any hints/tutorial/info?
>
> thanks
> Nico


OOcalc supports a little known feature whereby data can be
automatically sync'd between the spreadsheet and an HTML table.   A
few years ago I did up a demo of this in action using Tcl/Tk (http://
www.icanprogram.com/hosug).  It should not be too hard to port this
idea to Python.

bob



More information about the Python-list mailing list