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