Python 2:在 Excel 文件中写入时出现 ASCII 问题

Question

>问题草图：

UnicodeDecodeError: 'ascii' codec can't decode byte 0xe9 in position 0: ordinal not in range(128)

我正在尝试编写一个简单的 python 程序，该程序可以自动完成空白单元，上面同一列中出现的数据。

由于文件中有中文字符，我想到了ASCII的问题，所以我尝试将其更改为UTF-8。

代码如下所示：

#!/usr/bin/python
# -*- coding:utf-8 -*-
from xlrd import open_workbook
from xlwt import Workbook
from xlutils.copy import copy
rb = open_workbook('data.xls', 'utf-8')
wb = copy(rb)
sh = wb.get_sheet(0)
s = rb.sheet_by_index(0)
cols = s.ncols
rows = s.nrows
temp = 0
for cx in range(cols):
    for rx in range(rows):
        if s.cell_value(rowx = rx, colx = cx).encode('utf-8') != "":
            temp = s.cell_value(rowx = rx, colx = cx).encode('utf-8')
            print(temp) #to verify
        else:
            sh.write(rx, cx, temp)
wb.save('data.xls')

但是，问题仍然发生了。终端结果：

ZishengdeMacBook-Pro:Downloads zisheng$ python form.py
(printed result ignored, and it looked good)
Traceback (most recent call last):
  File "form.py", line 41, in <module>
    wb.save('data.xls')
  File "/Users/zisheng/anaconda/lib/python2.7/site-packages/xlwt/Workbook.py", line 710, in save
    doc.save(filename_or_stream, self.get_biff_data())
  File "/Users/zisheng/anaconda/lib/python2.7/site-packages/xlwt/Workbook.py", line 674, in get_biff_data
    shared_str_table   = self.__sst_rec()
  File "/Users/zisheng/anaconda/lib/python2.7/site-packages/xlwt/Workbook.py", line 636, in __sst_rec
    return self.__sst.get_biff_record()
  File "/Users/zisheng/anaconda/lib/python2.7/site-packages/xlwt/BIFFRecords.py", line 77, in get_biff_record
    self._add_to_sst(s)
  File "/Users/zisheng/anaconda/lib/python2.7/site-packages/xlwt/BIFFRecords.py", line 92, in _add_to_sst
    u_str = upack2(s, self.encoding)
  File "/Users/zisheng/anaconda/lib/python2.7/site-packages/xlwt/UnicodeUtils.py", line 50, in upack2
    us = unicode(s, encoding)
UnicodeDecodeError: 'ascii' codec can't decode byte 0xe9 in position 0: ordinal not in range(128)

有人可以帮忙吗？提前感谢！

我想通了！

为了解决这个问题，我们可以在写入过程中添加 UTF-8 表示法：

sh.write(rx, cx, unicode(temp, 'utf-8'))

大功告成。

Answer 1

问题解决了。

为了解决这个问题，我们可以在写入过程中添加 UTF-8 表示法：

sh.write(rx, cx, unicode(temp, 'utf-8'))