import subprocess
import sys
def install_package(package):
    try:
        # 檢查庫是否已安裝
        subprocess.check_call([sys.executable, '-m', 'pip', 'show', package], stdout=subprocess.DEVNULL, stderr=subprocess.DEVNULL)
        print(f"{package} 已安裝，無需操作。")
    except subprocess.CalledProcessError:
        print(f"正在安裝 {package}...")
        subprocess.check_call([sys.executable, '-m', 'pip', 'install', package])
        print(f"{package} 安裝成功。")
def uninstall_package(package):
    try:
        # 檢查庫是否已安裝
        subprocess.check_call([sys.executable, '-m', 'pip', 'show', package], stdout=subprocess.DEVNULL, stderr=subprocess.DEVNULL)
        print(f"正在卸載 {package}...")
        subprocess.check_call([sys.executable, '-m', 'pip', 'uninstall', package, '-y'])
        print(f"{package} 卸載成功。")
    except subprocess.CalledProcessError:
        print(f"{package} 未安裝，無需卸載。")
if __name__ == '__main__':
    # 要安裝的庫列表
    packages_to_install = ['openpyxl==3.1.3', 'xlrd', 'xlwt']
    # 安裝庫
    for package in packages_to_install:
        install_package(package)
    print("所有庫安裝完成。")
    # 要卸載的庫列表
    # packages_to_uninstall = ['openpyxl', 'xlrd', 'xlwt']
    #
    # # 安裝庫
    # for package in packages_to_uninstall:
    #     uninstall_package(package)
    #
    # print("所有庫卸載完成。")