python怎么保留格式写入excel

python怎么保留格式写入excel？

# 需安装 xlrd-0.9.2 和 xlutils-1.7.1 这两个模块 from xlwt import Workbook, Formula import xlrd book = Workbook() sheet1 = book.add_sheet('Sheet 1') sheet1.write(0,0,10) sheet1.write(0,1,20) sheet1.write(1,0,Formula('A1/B1')

) sheet2 = book.add_sheet('Sheet 2') row = sheet2.row(0) row.write(0,Formula('sum(1,2,3)')) row.write(1,Formula('SuM(1; 2; 3)')) row.write(2,Formula("$A$1+$B$1*SUM('ShEEt 1'!$A$1:$b$2)")) book.save('formula.xls') book = xlrd.open_workbook('formula.xls'

) sheet = book.sheets()[0] nrows=sheet.nrows ncols=sheet.ncols for i in range(nrows): for j in range(ncols): print (sheet.cell(i,j).value)

声明：本文内容由网友自发贡献，本站不承担相应法律责任。对本内容有异议或投诉，请联系2913721942#qq.com核实处理，我们将尽快回复您，谢谢合作！