python2：在Excel文件中写入时出现ASCII问题

Question

问题草图：

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

我试图编写一个简单的Python程序，它可以自动完成在同一列中出现的数据的空白单元。在

由于文件中有汉字，我想到了ASCII的问题，所以我试图将它改成UTF-8。在

代码如下：

^{pr2}$

然而，这个问题还是发生了。导致终端：

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'))