Question

用python 保存excel文件时出错如何 解决

创建一个excel 一个sheet 在里面写了点东西然后保存时出错 大神来救
我用的python3.2 模块是xlwt3





Answer 1

from xlutils.copy import copy
from xlrd import open_workbook
from xlwt import easyxf
import os

excel=r'c:/Users/fuxing/Desktop/testdata/test-insertdata.xls'
rb = open_workbook(excel,formatting_info=True)
wb = copy(rb)
sheet = wb.get_sheet(0)
#w_sheet = wb.get_sheet(0) # the sheet to write to within the writable copy

sheet.write(0, 4, '123321')
os.remove(excel)

wb.save(excel)
而且 确定你要写入的excel文件是 .xls

Answer 2

encoding= 'utf-8'