tanqiu/assets/data/excel/remove_sheet.py

import pandas as pd
import openpyxl
from pathlib import Path

def remove_sheet_from_excel(excel_path, sheet_name_to_remove):
    """
    从Excel文件中删除指定的工作表
    """
    try:
        # 使用openpyxl加载工作簿
        workbook = openpyxl.load_workbook(excel_path)
        
        # 检查工作表是否存在
        if sheet_name_to_remove in workbook.sheetnames:
            # 删除工作表
            del workbook[sheet_name_to_remove]
            print(f"已删除工作表: {sheet_name_to_remove}")
            
            # 保存文件
            workbook.save(excel_path)
            print(f"文件已保存: {excel_path}")
            
            # 显示剩余的工作表
            print(f"剩余工作表: {workbook.sheetnames}")
            return True
        else:
            print(f"工作表 '{sheet_name_to_remove}' 不存在")
            print(f"现有工作表: {workbook.sheetnames}")
            return False
            
    except Exception as e:
        print(f"删除工作表失败: {e}")
        return False

if __name__ == "__main__":
    excel_file = Path("d:/CocosGame/Pong/assets/data/excel/方块武器配置/方块武器配置表.xlsx")
    sheet_to_remove = "稀有度权重配置"
    
    print(f"正在从 {excel_file} 中删除工作表 '{sheet_to_remove}'...")
    success = remove_sheet_from_excel(excel_file, sheet_to_remove)
    
    if success:
        print("\n✅ 工作表删除成功！")
    else:
        print("\n❌ 工作表删除失败！")