ooolib, reading writing a spread sheet and keep formatting

Chris Withers chris at simplistix.co.uk
Tue May 4 07:23:26 EDT 2010


News123 wrote:
> 
> from xlrd import open_workbook
> from xlutils.copy import copy
> 
> rb =  open_workbook('doc1.xls')

open_workbook('doc1.xls',formatting_info=True)

> 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

cheers,

Chris




More information about the Python-list mailing list