Python openpyxl模块Excel 拆分

效率高于VBA 且容错率高

代码

from openpyxl import load_workbook
from openpyxl import workbook
import os
from openpyxl import Workbook

#load the workbook we want to manipuate
wb=load_workbook(filename='G:\\360MoveData\\Users\\Administrator\\Desktop\\王主任补充资料\\长4+5资料\\射孔段数据\\2-2016年投产投注地质方案.xlsx') 
#review the names of all worksheets of the workbook
F='G:\\360MoveData\\Users\\Administrator\\Desktop\\王主任补充资料\\长4+5资料\\射孔段数据\\2016拆分'
ws_name =wb.get_sheet_names()
#print(ws_name)
len(ws_name)

m=0
for name in ws_name:
    m=m+1
    F1=os.path.join(F,name)
    ws=wb.get_sheet_by_name(name)
    wb

n=0
for name in ws_name:
    n=n+1
    F1=os.path.join(F,name+'.xlsx')
    print(F1)
    ws_old =wb.get_sheet_by_name(name)
    wb_new = Workbook()
    ws_new =wb_new.active
    ws_new.title = name
    print(n)
    for i,row in enumerate(ws_old.iter_rows()):
        for j,cell in enumerate(row):
            ws_new.cell(row=i+1, column=j+1, value=cell.value)

    wb_new.save(F1)