ooolib, reading writing a spread sheet and keep formatting

[News123]

News123 wrote:
> 
> Kushal Kumaran wrote:
>> On Thu, Apr 29, 2010 at 5:46 AM, News123 <news1234 at free.fr> wrote:
>>> Hi,
>>>
>>> I'm making first attempts to modify a few cells of an openoffice
>>> spreadsheet.
>>>
>> Try the xlrd and xlwt modules, and the documentation at
>> http://www.python-excel.org/

> I installed xlrd, xlwt and xlsutils
> 
> Now I'm stuck with exactly the same probem, that I had with ooolib.
> The newly written file lost all formating and replaced formulas with the
> calculated values.
> 

Well the xlsutils documentation states clearly:
> It is important to note that some things won't be copied:
>         Formulae
>      •
>         Names
>      •
>         anything ignored by xlrd
>      •


So probably I can't use xlrd / xlwt to perform my desired task. :-(
(Or it least I don't know how)

For extracting data or creating xls from scratch t seems rather nice though


bye


N