使用python的xlwt库写入xls的时候,报错
Exception: String longer than 32767 characters
解决办法:
使用xlsxwriter库,
这个库是将数据截断,但是不会报错
import xlsxwriter
def write_excel_xls(path, sheet_name, value):
index = len(value)
workbook = xlsxwriter.Workbook(path)
sheet = workbook.add_worksheet(sheet_name)
for i in range(0, index):
for j in range(0, len(value[i])):
sheet.write(i, j, value[i][j])
workbook.close()
value = [['Rent', 1000],
['Gas', 100],
['Food', 300],
['Gym', 50],]
write_excel_xls("export.xlsx","导出",value)