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

--
http://mail.python.org/mailman/listinfo/python-list

Reply via email to