python将数据写入EXCEL出错

发布网友发布时间：2022-04-23 16:42

共2个回答

懂视网时间：2022-05-10 19:20

下面为大家分享一篇Python 解决中文写入Excel时抛异常的问题，具有很好的参考价值，希望对大家有所帮助。一起过来看看吧

近期接到业务部门需求，需将统计结果每日发送到业务部门，在调试python脚本的时候，导出的Excel标题为中文，总是抛出以下异常

Traceback (most recent call last): 
 File "totalpx.py", line 99, in <module> 
 export() 
 File "totalpx.py", line 54, in export 
 workbook.save(out_path) 
 File "/usr/lib/python2.7/site-packages/xlwt-1.2.0-py2.7.egg/xlwt/Workbook.py", line 710, in save 
 doc.save(filename_or_stream, self.get_biff_data()) 
 File "/usr/lib/python2.7/site-packages/xlwt-1.2.0-py2.7.egg/xlwt/Workbook.py", line 674, in get_biff_data 
 shared_str_table = self.__sst_rec() 
 File "/usr/lib/python2.7/site-packages/xlwt-1.2.0-py2.7.egg/xlwt/Workbook.py", line 636, in __sst_rec 
 return self.__sst.get_biff_record() 
 File "/usr/lib/python2.7/site-packages/xlwt-1.2.0-py2.7.egg/xlwt/BIFFRecords.py", line 77, in get_biff_record 
 self._add_to_sst(s) 
 File "/usr/lib/python2.7/site-packages/xlwt-1.2.0-py2.7.egg/xlwt/BIFFRecords.py", line 92, in _add_to_sst 
 u_str = upack2(s, self.encoding) 
 File "/usr/lib/python2.7/site-packages/xlwt-1.2.0-py2.7.egg/xlwt/UnicodeUtils.py", line 50, in upack2 
 us = unicode(s, encoding) 
UnicodeDecodeError: 'ascii' codec can't decode byte 0xe6 in position 0: ordinal not in range(128)

解决方法是，在创建workbook的时候设置字符集即可解决：

workbook = xlwt.Workbook(encoding = 'utf-8')

正常默认编码是ascii，所以写入中文解码会抛异常，设置为utf-8就行。

热心网友时间：2022-05-10 16:28

from openpyxl import Workbook
from openpyxl import load_workbook
from openpyxl.writer.excel import Excelwriter
wb=wordbook()
ws=wb.active
ws.cell(1.1).value='hello excel'
for i in range(2,5):
for j in range(2,6):
ws.cell(i+1,j+1).value=i*j
wb.save('text.xlsx')

看报错是缩进导致的的，python是强制缩进的，缩进是代码的一部分

python里面的缩进，相当于C语言的里面的花括号。

另外还一个问题就是结尾的分号;应该是冒号:，具体参见上面的代码