# -*- coding:utf-8 -*-
# @Time   : 2022-05-30
# @Author : carl_DJ
import PySimpleGUI as psg
"选择日期"
# 显示一个日历窗口, 通过用户的选择, 返回一个元组(月, 日, 年)
date = psg.popup_get_date()
if not date:
    psg.popup("Cancel", "No date picked")
    raise SystemExit("Cancelling: no date picked")
else:
    psg.popup("The date you chose was", date)

# -*- coding:utf-8 -*-
# @Time   : 2022-05-30
# @Author : carl_DJ
import PySimpleGUI as psg
"弹窗"
#显示一个弹窗, 但没有任何按钮
psg.popup_no_buttons("You cannot click any buttons")
# 显示一个没有标题栏的弹窗
psg.popup_no_titlebar("A very simple popup")
# 显示弹窗且只有OK按钮
psg.popup_ok("You can only click on 'OK'")
# 显示弹窗且只有error按钮, 按钮带颜色
psg.popup_error("Something went wrong")
# 显示一个“通知窗口”, 通常在屏幕的右下角, 窗口会慢慢淡入淡出
psg.popup_notify("Task done!")

# -*- coding:utf-8 -*-
# @Time   : 2022-05-30
# @Author : carl_DJ
import PySimpleGUI as psg
"选择弹窗"
# 显示弹窗以及是和否按钮, 选择判断
answer = psg.popup_yes_no("Do you like 王心凌?")
psg.popup("You have selected", answer)

# -*- coding:utf-8 -*-
# @Time   : 2022-05-30
# @Author : carl_DJ
import PySimpleGUI as psg
"选择弹窗"
# 显示弹窗以及是和否按钮, 选择判断
answer = psg.popup_yes_no("Do you like 王心凌?")
psg.popup("You have selected", answer)

# -*- coding:utf-8 -*-
# @Time   : 2022-05-30
# @Author : carl_DJ
from pathlib import Path
import PySimpleGUI as psg
import xlwings as xlw
# 选择输入文件夹
INPUT_DIR = psg.popup_get_folder("Select an input folder")
if not INPUT_DIR:
    psg.popup("Cancel", "No folder selected")
    raise SystemExit("Cancelling: no folder selected")
else:
    INPUT_DIR = Path(INPUT_DIR)
# 选择输出文件夹
OUTPUT_DIR = psg.popup_get_folder("Select an output folder")
if not OUTPUT_DIR:
    psg.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):
        # 显示进度
        psg.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()
psg.popup_ok("Task done!")