Peter Morgan wrote:
> import LibreOffice as LO
>
> spread_full_path = "/jobs/%s/my_calc_spread_sheet.odf" % JOB.job_id #
> whatever extension
>
> spreadMe = LO.open(spread_full_path)
>
> mySheet = spreadMe.sheet("foo", create=True) # create's if not exist,
> otherwise error
>
> mySheet.append( My_Data )
>
> mySheet.close()
>
Hi Pete,
well you can use the normal Calc API also via Python, if Danny's
wrappers are not enough - it's almost as easy:
import uno, unohelper
...
oDoc = desktop.loadComponentFromURL( "file.ods", "_blank", 0, () )
oSheet = oDoc.getSheets().getByName( "My Sheet" )
oSheet.Rows.getByIndex(2).CellBackColor = long('00EEEEEE', 16)
...
etc - more details, bootstrapping tips etc here:
http://wiki.services.openoffice.org/wiki/Python
(http://www.linuxjournal.com/content/starting-stopping-and-connecting-openoffice-python
may be a nice concise intro text)
> In conclusion:
> Anyone into developing the python.API and making it simple and idiot proff
>
The "python API" is the normal LibO API, i.e. the same for Java,
Basic, Python etc - the python binding works well for me, Danny's
wrapper is nice - but he's the one to be asked for development
there.
Cheers,
-- Thorsten
pgpMiF5BoH9ru.pgp
Description: PGP signature
_______________________________________________ LibreOffice mailing list LibreOffice@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice
