这段时间在工作中总遇到excel拆分,今天下午就有一个需求,一个excel有11个sheet,每个sheet均需根据部门拆分,最终形成按部门命名的excel,此excel里每个sheet均为该部门的数据。因为工作环境中没有相关环境,分了一下午才分好,太费时了,回来自己写程序,下次就可以轻松搞定啦
import pandas as pd
dirPath = 'D:/study/pythonTest/excelC/'
path = dirPath + 'test.xlsx'
orgName = pd.read_excel(path,'XX')
org_list = list(orgName['XX名称'].drop_duplicates())
print(org_list)
#获取sheet名称
d_read = pd.read_excel(path,None)
names=list(d_read.keys())
print(type(names),names)
for i in org_list:
writer = pd.ExcelWriter(dirPath+i+'.xlsx')
for name in names:
print(name)
tempsheet=pd.read_excel(path,sheet_name=name)
tempdata = tempsheet[tempsheet['XX名称']==i]
tempdata.to_excel(writer, sheet_name = name,index = False)
writer.save()
writer.close()