ooolib, reading writing a spread sheet and keep formatting

[News123]

Hi Chris,


Chris Withers wrote:
> News123 wrote:
>>
>> from xlrd import open_workbook
>> from xlutils.copy import copy
>>
>> rb =  open_workbook('doc1.xls')
> 
> open_workbook('doc1.xls',formatting_info=True)

I'll try, but the doc mentioned explicitely, that formulas will be lost.
I'll keep you updated.


> 
>> print "WB with %d sheets" % rb.nsheets
>> wb = copy(rb)
>> wb.save("doc2.xls") # file is created, but ALL formattng is lost and
>> formulas are now diplayed as text
> 

>