Python Excel 拆分（按某列分组生成多个表）
import pandas as pd
df = pd.read_excel('总表.xlsx')
for name, group in df.groupby('部门'):
group.to_excel(f'拆分_{name}.xlsx', index=False)
print(f"生成：拆分_{name}.xlsx")
df = pd.read_excel('总表.xlsx')
for name, group in df.groupby('部门'):
group.to_excel(f'拆分_{name}.xlsx', index=False)
print(f"生成：拆分_{name}.xlsx")
更新时间：2026-09-14 13:12:55