1 代码实现

import pandas as pd
import xlsxwriter
from xlwt import Workbook

data=pd.read_excel(r'****待拆分文件路径******.xlsx',encode='gbk')
area_list=list(set(data[u'*****列名称***']))

for j in area_list:
    file_name = str(j)
    file_route =  "****拆分后文件保存路径*****" + str(j) + ".xls"
    book = Workbook(encoding='utf-8')
    sheet1 = book.add_sheet('Sheet2')
    book.save(file_route)
    writer=pd.ExcelWriter(file_route,engine='xlsxwriter')
    df=data[data[u'*****列名称******']==j]
    df.to_excel(file_route,sheet_name="Sheet1",index=False)
print("DONE!")