1、import xlrd,xlwt,xlsxwriterfrom xlutils.copy import copyfrom datetime import date,datetimeimport sysreload(sys)sys.setdefaultencoding('utf-8')
2、class WtXls(object):"""创建excel"""def __init__(self,file_name):super(WtXls, self).__init__()self.file_name = file_nameself.book=xlwt.Workbook()def add_sheet(self,sheet_name):#新增一个sheet，避免重复操作单元格报错：cell_overwrite_ok=Trueself.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):#保存excelself.book.save(self.file_name)return True
