python创建xls

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