ooolib, reading writing a spread sheet and keep formatting
news1234 at free.fr
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
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
doc.save("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