Question

PYTHON使用XLWT3保存EXCEL 出现AttributeError: 'bytes' object has no attribute 'encode'错误

以下代码

#!/usr/bin/env python
#-*- coding:utf-8 -*-
import xlrd
import xlwt3
workbook = xlwt3.Workbook(encoding='utf-8', style_compression=0)
worksheet = workbook.add_sheet('MyWorksheet', cell_overwrite_ok=True)
worksheet.write(0,0,'this should overwrite')
savePath= r'C:\Documents and Settings\Administrator\桌面\Excel_Save.xls'
workbook.save(savePath)
出错如下：
Current directory: C:\Documents and Settings\Administrator\桌面
Traceback (most recent call last):
File "new 1.txt", line 11, in <module>
workbook.save(savePath)
File "C:\Python34\lib\site-packages\xlwt3\workbook.py", line 216, in save
doc.save(filename, self.get_biff_data())
File "C:\Python34\lib\site-packages\xlwt3\workbook.py", line 497, in get_biff_data
self.__write_access_rec(),
File "C:\Python34\lib\site-packages\xlwt3\workbook.py", line 348, in __write_access_rec
return biffrecords.WriteAccessRecord(owner).get()
File "C:\Python34\lib\site-packages\xlwt3\biffrecords.py", line 235, in __init__
uowner.encode('utf-8'), b' '*(0x70 - uowner_len)) # (to_py3): added b'...'
AttributeError: 'bytes' object has no attribute 'encode'
================ READY ================

我是WINDOWS XP 32系统，EXCEL是2010,请问是什么原因导致不能保存该文件

Answer 1

把C:\Python34\lib\site-packages\xlwt3\biffrecords.py文件第235行中的uowner.encode('utf-8')改成uowner即可。
xlwt3有bug的。