代码之家  ›  专栏  ›  技术社区  ›  Zisheng Ye

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

  •  0
  • Zisheng Ye  · 技术社区  · 8 年前

    问题示意图:

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

    一切都结束了。

    1 回复  |  直到 8 年前
        1
  •  0
  •   Zisheng Ye    8 年前

    问题已解决。

    为了解决这个问题,我们可以在编写过程中添加UTF-8符号:

    sh.write(rx, cx, unicode(temp, 'utf-8'))
    
    推荐文章