[plug] openoffice calc api

[Steve Boak]

On Thursday 02 August 2007 12:22, W.Kenworthy wrote:
> Its been awhile, but perl has modules to write data into excel and csv
> files.  Worked fine when I used them.
>
> BillK

Thanks Bill, I know about the .xls and .csv tools, but I'm trying to store 
data directly into an already existing OO calc spreadsheet. I thought 
automatically generating or modifying calc spreadsheets would have been a 
relatively common activity - looks like I was mistaken :-)

If it helps anyone else, I have found the Python-UNO bridge:
<http://udk.openoffice.org/python/python-bridge.html>
Using the supplied example Python script I can add text to an already open 
text document, so it does seem to work.

I'll be having a closer look at this example in the next couple of days:
<http://www.stuvel.eu/ooo-python>
It looks like a workable starting point for writing to calc spreadheets... 

The "The OpenOffice.org ODF Toolkit Project" 
<http://odftoolkit.openoffice.org/> looks promising, but it's only in the 
discussion stage at the moment.

Steve

>
> On Thu, 2007-08-02 at 11:53 +0800, Steve Boak wrote:
> > Hi All
> >
> > I'm trying to update a couple of fields in an openoffice calc spreadsheet
> > with data from an automated weather station but I'm having trouble
> > finding an API to do it.
> >
> > I'm currently using a perl script to save the data into a mysql database,
> > but I'd like to have my spreadsheet updated automatically with the daily
> > min, max and rainfall data instead of doing it manually when I remember
> > :-)
> >
> > I have found stuff on writing csv or xls files, but that still leaves me
> > with manually importing that into calc.
> >
> > perl, python, php, shell, any interface will do :-)
> >
> > Thanks for any ideas...
> >
> > Steve
> > _______________________________________________
> > PLUG discussion list: plug at plug.org.au
> > http://www.plug.org.au/mailman/listinfo/plug
> > Committee e-mail: committee at plug.linux.org.au
>
> _______________________________________________
> PLUG discussion list: plug at plug.org.au
> http://www.plug.org.au/mailman/listinfo/plug
> Committee e-mail: committee at plug.linux.org.au