python实现跨excel的工作表sheet之间的复制方法

from openpyxl import load_workbook

filename = 'test1.xlsx'

filename2 = 'test2.xlsx'

def replace_xls(sheetname):

 wb = load_workbook(filename)

 wb2 = load_workbook(filename2)

 ws = wb[sheetname]

 ws2 = wb2[sheetname]

 #两个for循环遍历整个excel的单元格内容

 for i,row in enumerate(ws.iter_rows()):

  for j,cell in enumerate(row):

   ws2.cell(row=i+1, column=j+1, value=cell.value)

 wb2.save(filename2)

sheetnames = [u'Sheet1',u'Sheet2',u'Sheet3',u'Sheet4']

#遇到复制几十个sheet时候，很有必要写个循环

for sheetname in sheetnames:

 replace_xls(sheetname)