用save方法保存xlsx 无法识别
来源：6-5 如何读写excel文件
杨九爷
2016-09-29
#coding:utf8
import xlrd,xlwt
rbook = xlrd.open_workbook('demo.xlsx')
rsheet = rbook.sheet_by_index(0)
nc = rsheet.ncols
rsheet.put_cell(0,nc,xlrd.XL_CELL_TEXT,u'总分',None)
for row in range(1,rsheet.nrows):
t = sum(rsheet.row_values(row,1))
rsheet.put_cell(row,nc,xlrd.XL_CELL_NUMBER,t,None)
wbook = xlwt.Workbook()
wsheet = wbook.add_sheet(rsheet.name)
#style = xlwt.easyxf('align:vertical center,horizontal center')
for r in range(rsheet.nrows):
for c in range(rsheet.ncols):
wsheet.write(r,c,rsheet.cell_value(r,c))
wbook.save('output.xlsx')用这个方式保存的xlsx文件无法识别？求教！
写回答
2回答
-
可以试下最后一行修改为:wbook.save('output.xls')...
原因可能是xlwt对xlsx的support不好, 如果一定要save as xlsx file, you can try openpyxl.
212016-09-29 -
weibo_字无忌_0
2017-01-07
111
00
相似问题