1、import xlrd,xlwt,xlsxwriter
from xlutils.copy import copy
from datetime import date,datetime
import sys
reload(sys)
sys.setdefaultencoding('utf-8')
2、class WtXls(object):
"""创建excel"""
def __init__(self,file_name):
super(WtXls, self).__init__()
self.file_name = file_name
self.book=xlwt.Workbook()
def add_sheet(self,sheet_name):
#新增一个sheet，避免重复操作单元格报错：cell_overwrite_ok=True
self.sheet=self.book.add_sheet(sheet_name,cell_overwrite_ok=True)
return self.sheet
3、def write_rows(self,sheet,nrow,mcols,values):
#从第mcols列开始填充第nrow行数据
for mcol in range(0,len(values)):
sheet.write(nrow,mcol+mcols,values[mcol])
return True
4、def write_cols(self,sheet,nrows,mcol,values):
#从第nrows行开始填充第mcol列数据
for nrow in range(0,len(values)):
sheet.write(nrow+nrows,mcol,values[nrow])
return True
5、def write_merge(self,sheet,nrows_mcols):
#填充合并单元格
for nrow_mcol in nrows_mcols:
sheet.write_merge(nrow_mcol[0],nrow_mcol[1],nrow_mcol[2],nrow_mcol[3],nrow_mcol[4])
return True
6、def save_file(self):
#保存excel
self.book.save(self.file_name)
return True
