Generating a Spreadsheet via Python

[fatchan]

Hi All,

I have a bunch of statistical data that I would like to format into a spreadsheet with python. The easiest route i could think of was to use python to generate a csv file, but the problem is i want to have a more robust spreadsheet capable of representing different colored cells. Has anyone tried to use python to generate SXW files?

I did a quick search on this matter but could not find a post with the answer i seek, any help would be appreciated,.

Thanks a lot.

[hol.sten]

[DannyB]

[shunting]

D:\otherwhere>python
Python 2.2.2 (#37, Oct 14 2002, 17:02:34) [MSC 32 bit (Intel)] on win32
Type "help", "copyright", "credits" or "license" for more information.
>>> import uno
Traceback (most recent call last):
File "<stdin>", line 1, in ?
File "C:\Program Files\OpenOffice.org1.1.4\program\uno.py", line 67, in ?
_g_ctx = pyuno.getComponentContext( )
SystemError: Error during bootstrapping uno (uno::Exception):loading component library failed: file:///C:/Program%20Files/OpenOffice.org1.1.4/program/simplereg.uno.dll
>>>

Using python.bat

Python 2.2.2 (#37, Oct 14 2002, 17:02:34) [MSC 32 bit (Intel)] on win32
Type "help", "copyright", "credits" or "license" for more information.
>>> import uno
>>>

Surely I don't have to run my python scripts from the OpenOffice directory to get pyuno to work, so what am I doing wrong?

[DannyB]

[sam_hunting]

Thanks, Danny. I've written a batch file to set the environement variables.

Hopefully the new OpenOffice will improve some of these limitations....

[DannyB]