該樓層疑似違規(guī)已被系統(tǒng)折疊?隱藏此樓查看此樓

#coding=utf-8

import xlrd

import xlwt

from xlutils.copy import copy

sheetIndex=-1

file=xlrd.open_workbook(u'中文文件.xlsx')

writeFile=copy(file)

writeFile.encoding='utf8'

for sheet in file.sheets():

sheetIndex=sheetIndex+1

for rownum in range(1,sheet.nrows):

key=sheet.cell(rownum,4).value

val=sheet.cell(rownum,3).value

writeSheet=writeFile.get_sheet(sheetIndex)

writeSheet.write(rownum,4,(key+u'啊').encode('utf8'))

writeSheet.write(rownum,3,(val+u'1').encode('utf8')

writeFile.save(u'中文文件.xlsx')

下面是出錯(cuò)信息

Traceback (most recent call last):

File "D:\PythonTest\ReplaceNationName.py", line 28, in

writeFile.save(u'中文文件.xlsx')

File "D:\Program Files\Python276\lib\site-packages\xlwt\Workbook.py", line 662, in save

doc.save(filename, self.get_biff_data())

File "D:\Program Files\Python276\lib\site-packages\xlwt\Workbook.py", line 637, in get_biff_data

shared_str_table = self.__sst_rec()

File "D:\Program Files\Python276\lib\site-packages\xlwt\Workbook.py", line 599, in __sst_rec

return self.__sst.get_biff_record()

File "D:\Program Files\Python276\lib\site-packages\xlwt\BIFFRecords.py", line 76, in get_biff_record

self._add_to_sst(s)

File "D:\Program Files\Python276\lib\site-packages\xlwt\BIFFRecords.py", line 91, in _add_to_sst

u_str = upack2(s, self.encoding)

File "D:\Program Files\Python276\lib\site-packages\xlwt\UnicodeUtils.py", line 50, in upack2

us = unicode(s, encoding)

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

總結(jié)

以上是生活随笔為你收集整理的python写excel文件出错_【求教】xlutils修改中文Excel文件出错的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問(wèn)題。

如果覺(jué)得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。