# 安裝PySimpleGUI
pip install PySimpleGUI -i https://mirror.baidu.com/pypi/simple

import PySimpleGUI as sg
 
# 窗口顯示文本框和瀏覽按鈕, 以便選擇一個文件夾
dir_path = sg.popup_get_folder("Select Folder")
if not dir_path:
    sg.popup("Cancel", "No folder selected")
    raise SystemExit("Cancelling: no folder selected")
else:
    sg.popup("The folder you chose was", dir_path)

# 窗口顯示文本框和瀏覽按鈕, 以便選擇文件
fname = sg.popup_get_file("Choose Excel file", multiple_files=True, file_types=(("Excel Files", "*.xls*"),),)
if not fname:
    sg.popup("Cancel", "No filename supplied")
    raise SystemExit("Cancelling: no filename supplied")
else:
    sg.popup("The filename you chose was", fname)

# 顯示一個日歷窗口, 通過用戶的選擇, 返回一個元組(月, 日, 年)
date = sg.popup_get_date()
if not date:
    sg.popup("Cancel", "No date picked")
    raise SystemExit("Cancelling: no date picked")
else:
    sg.popup("The date you chose was", date)

# 顯示文本輸入框, 輸入文本信息, 返回輸入的文本, 如果取消則返回None
text = sg.popup_get_text("Please enter a text:")
if not text:
    sg.popup("Cancel", "No text was entered")
    raise SystemExit("Cancelling: no text entered")
else:
    sg.popup("You have entered", text)

# 顯示一個彈窗, 但沒有任何按鈕
sg.popup_no_buttons("You cannot click any buttons")

# 顯示一個沒有標(biāo)題欄的彈窗
sg.popup_no_titlebar("A very simple popup")

# 顯示彈窗且只有OK按鈕
sg.popup_ok("You can only click on 'OK'")

# 顯示彈窗且只有error按鈕, 按鈕帶顏色
sg.popup_error("Something went wrong")

# 顯示一個“通知窗口”, 通常在屏幕的右下角, 窗口會慢慢淡入淡出
sg.popup_notify("Task done!")

# 顯示彈窗以及是和否按鈕, 選擇判斷
answer = sg.popup_yes_no("Do you like this video?")
sg.popup("You have selected", answer)

# 自定義創(chuàng)建彈窗, 一行代碼完成
choice, _ = sg.Window(
    "Continue?",
    [[sg.T("Do you want to subscribe to this channel?")], [sg.Yes(s=10), sg.No(s=10), sg.Button('Maybe', s=10)]],
    disable_close=True,
).read(close=True)
sg.popup("Your choice was", choice)

from pathlib import Path
import PySimpleGUI as sg
import xlwings as xw
 
# 選擇輸入文件夾
INPUT_DIR = sg.popup_get_folder("Select an input folder")
if not INPUT_DIR:
    sg.popup("Cancel", "No folder selected")
    raise SystemExit("Cancelling: no folder selected")
else:
    INPUT_DIR = Path(INPUT_DIR)
 
# 選擇輸出文件夾
OUTPUT_DIR = sg.popup_get_folder("Select an output folder")
if not OUTPUT_DIR:
    sg.popup("Cancel", "No folder selected")
    raise SystemExit("Cancelling: no folder selected")
else:
    OUTPUT_DIR = Path(OUTPUT_DIR)
 
# 獲取輸入文件夾中所有xls格式文件的路徑列表
files = list(INPUT_DIR.rglob("*.xls*"))
 
with xw.App(visible=False) as app:
    for index, file in enumerate(files):
        # 顯示進(jìn)度
        sg.one_line_progress_meter("Current Progress", index + 1, len(files))
        wb = app.books.open(file)
        # 提取sheet表為單獨的Excel表格
        for sheet in wb.sheets:
            wb_new = app.books.add()
            sheet.copy(after=wb_new.sheets[0])
            wb_new.sheets[0].delete()
            wb_new.save(OUTPUT_DIR / f"{file.stem}_{sheet.name}.xlsx")
            wb_new.close()
 
sg.popup_ok("Task done!")