import pandas as pd
import numpy as np

path = r"d:\test\test.xlsx"

df = pd.DataFrame()
df.to_excel(path)  # 确保path存在 否则excelwriter会报错

with pd.ExcelWriter(path, mode="a", engine="openpyxl") as writer:
    for sht in list(map(chr, range(97, 97 + 2)))[::-1]:
        df.to_excel(writer, sht)

print(
    pd.ExcelFile(
        path
    ).sheet_names
)

# 读取后字典是否会自动排序?
print(
    pd.read_excel(
        path,
        None
    ).keys()
)
# 不自动排序 放心了!