一个用于将Excel文件中的多个sheet拆分为独立Excel文件的Python工具。 documents/split_output/ ├── 收入.xlsx ├── 支出.xlsx ├── 汇总.xlsx ├── Q1.xlsx ├── Q2.xlsx ├── Q3.xlsx ├── Q4.xlsx ...
# file_path = 'Excel-Split.xlsx' # Replace 'input_file.xlsx' with your Excel file path df = pd.read_excel(excel_path) # Identify unique values in the column for splitting # excel_column = 'Branch' # ...