欧元符号- xlsxwriter错误

Question

我试图从一个网页中获取一些数据，并将这些数据写入xlsx文件。一切看起来都很好，但如果在关闭文件时尝试将其写入xlsx文件，则可能会引发编码错误。

错误：

Traceback (most recent call last):
  File "C:/Users/Milano/PycharmProjects/distrelec/crawler.py", line 429, in <module>
    temp_file_to_xlsx()
  File "C:/Users/Milano/PycharmProjects/distrelec/crawler.py", line 119, in temp_file_to_xlsx
    wb.close()    
  File "C:\Python27\lib\site-packages\xlsxwriter\workbook.py", line 295, in close
    self._store_workbook()
  File "C:\Python27\lib\site-packages\xlsxwriter\workbook.py", line 518, in _store_workbook
    xml_files = packager._create_package()
  File "C:\Python27\lib\site-packages\xlsxwriter\packager.py", line 134, in _create_package
    self._write_workbook_file()
  File "C:\Python27\lib\site-packages\xlsxwriter\packager.py", line 174, in _write_workbook_file
    workbook._assemble_xml_file()
  File "C:\Python27\lib\site-packages\xlsxwriter\workbook.py", line 464, in _assemble_xml_file
    self._write_sheets()
  File "C:\Python27\lib\site-packages\xlsxwriter\workbook.py", line 1455, in _write_sheets
    self._write_sheet(worksheet.name, id_num, worksheet.hidden)
  File "C:\Python27\lib\site-packages\xlsxwriter\workbook.py", line 1472, in _write_sheet
    self._xml_empty_tag('sheet', attributes)
  File "C:\Python27\lib\site-packages\xlsxwriter\xmlwriter.py", line 80, in _xml_empty_tag
    self.fh.write("<%s/>" % tag)
  File "C:\Python27\lib\codecs.py", line 694, in write
    return self.writer.write(data)
  File "C:\Python27\lib\codecs.py", line 357, in write
    data, consumed = self.encode(object, self.errors)
UnicodeDecodeError: 'ascii' codec can't decode byte 0xe2 in position 23: ordinal not in range(128)

要找出我编辑过的codecs模块的问题所在：

def write(self, object):

        """ Writes the object's contents encoded to self.stream.
        """
        try:
            data, consumed = self.encode(object, self.errors)
            self.stream.write(data)
        except:
            print object
            print repr(object)
            raise Exception

产出如下：

<sheet name="Android PC–APC" sheetId="42" r:id="rId42"/>
'<sheet name="Android PC\xe2\x80\x93APC" sheetId="42" r:id="rId42"/>'
    temp_file_to_xlsx()
  File "C:/Users/Milano/PycharmProjects/distrelec/crawler.py", line 119, in temp_file_to_xlsx
    wb.close()    
  File "C:\Python27\lib\site-packages\xlsxwriter\workbook.py", line 295, in close
    self._store_workbook()
  File "C:\Python27\lib\site-packages\xlsxwriter\workbook.py", line 518, in _store_workbook
    xml_files = packager._create_package()
  File "C:\Python27\lib\site-packages\xlsxwriter\packager.py", line 134, in _create_package
    self._write_workbook_file()
  File "C:\Python27\lib\site-packages\xlsxwriter\packager.py", line 174, in _write_workbook_file
    workbook._assemble_xml_file()
  File "C:\Python27\lib\site-packages\xlsxwriter\workbook.py", line 464, in _assemble_xml_file
    self._write_sheets()
  File "C:\Python27\lib\site-packages\xlsxwriter\workbook.py", line 1455, in _write_sheets
    self._write_sheet(worksheet.name, id_num, worksheet.hidden)
  File "C:\Python27\lib\site-packages\xlsxwriter\workbook.py", line 1472, in _write_sheet
    self._xml_empty_tag('sheet', attributes)
  File "C:\Python27\lib\site-packages\xlsxwriter\xmlwriter.py", line 80, in _xml_empty_tag
    self.fh.write("<%s/>" % tag)
  File "C:\Python27\lib\codecs.py", line 699, in write
    return self.writer.write(data)
  File "C:\Python27\lib\codecs.py", line 363, in write
    raise Exception
Exception

我该怎么处理呢？

Answer 1

您必须使用正确的编码对输入数据进行解码，这似乎是“utf-8”。

Answer 2

你可能想看看这个：

示例:使用Python 2的简单Unicode