modifying open office spreadsheet (with OO installed)

News123 news1234 at free.fr
Thu May 6 03:34:50 EDT 2010


Hi CHris,


Chris Withers wrote:
> Jim Byrnes wrote:
>> News123 wrote:
>>> Mumbling to myself, perhaps somebody else is interested.
>>
>> Yes I am.
>>
>>> News123 wrote:
>>>> Hi,
>>>>
>>>>
>>>> I wanted to know who can recommend a good module/library, that
>>>> allows to
>>>> modify an Open Office spreadsheet.
>>>>
>>>> One can assume, that Open Office is installed on the host.
>>>>
>>>>
>>> Following url gives a small introduction about using the PyUno-bridge to
>>> open-read-modify-save a spread sheet
>>> http://stuvel.eu/ooo-python
> 
> If .xls files are an option for you, xlutils.copy is your friend:
> 
> https://secure.simplistix.co.uk/svn/xlutils/trunk/xlutils/docs/copy.txt
> 

In fact I like this library and for some things I intend to do it's a
rather nice option.

However for changing a few fields and keeping all the rest exactly as it
is it doesn't seem to be the most apropriate solution (without some hacking)
as formulas might get lost.


> cheers,
> 
> Chris
> 



More information about the Python-list mailing list