excel拆分工作表sheet

import openpyxl
import os

def save_each_sheet_as_xlsx(input_file):
    wb = openpyxl.load_workbook(input_file)

    for sheet_name in wb.sheetnames:
        new_wb = openpyxl.Workbook()
        new_sheet = new_wb.active
        sheet = wb[sheet_name]

        for row in sheet.iter_rows(values_only=True):
            new_sheet.append(row)

        new_file_name = os.path.splitext(input_file)[0] + f'_{sheet_name}.xlsx'
        new_wb.save(new_file_name)
        print(f"工作表 '{sheet_name}' 已保存为 {new_file_name}")

if __name__ == "__main__":
    input_file = "path"  # 将其替换为你的文件名
    save_each_sheet_as_xlsx(input_file)