ooolib, reading writing a spread sheet and keep formatting

News123 news1234 at
Thu Apr 29 02:16:02 CEST 2010


I'm making first attempts to modify a few cells of an openoffice

I thought I'll start with ooolib as it seems rather simple.

( linux / open office 3.1 / ooolib-python-0.0.16 )

My first test was just to open a spread sheet

import ooolib
doc = ooolib.Calc()
doc.load("doc1.ods") # load calc file
doc.set_sheet_index(0) # select first sheet
doc_dims =  doc.get_sheet_dimensions() # get sheet dimensions
print "dims",doc_dims # and print them out"doc2.ods") # save 'unmodfified' file

Extracting data works perfectly.

However the saved file lost all its formating and keeps only the data.

What am I doing wrong?

My goal is to just change one cell value, but to keep all the formatting
(at least of the other cells)

thanks for any hints


More information about the Python-list mailing list