python生成的excel无法打开-Python 解决中文写入Excel时抛异常的问题

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

Traceback (most recent call last):

File "totalpx.py", line 99, in

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/x