python的xlwt库写入报错Exception: String longer than 32767 characters

148 阅读 0 评论 98 点赞

我是靠谱客的博主秀丽小兔子，这篇文章主要介绍python的xlwt库写入报错Exception: String longer than 32767 characters，现在分享给大家，希望可以做个参考。

使用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)