python创建xls

1、import xlrd,xlwt,xlsxwriterfrom xlutils.copy import copyfrom datetime import date,datetimeimport sysreload(sys)sys.setdefaultencoding('utf-8')

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

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