关于 DataFrame：多Sheet Exceld的保存和读取

import numpy as np
import pandas as pd
# import xlrd

1. 往一个excel里存多个Sheet

# 往一个excel里存多个Sheet
import pandas as pd
route = r'./data/demo.xlsx'
with pd.ExcelWriter(route) as writer:
    sum_df.to_excel(writer, sheet_name='门店',index=False)
    hjhb_df.to_excel(writer, sheet_name='合计环比',index=False)
    hjhb_kebi_df.to_excel(writer,sheet_name='合计环比（可比）',index = False)

2. 同时读取一个excel表中的多个Sheet

# 同时读取一个excel表中的多个Sheet
route = './data/XXX.xlsx'
reader = pd.ExcelFile(route)
sheet_names = reader.sheet_names
dfs = pd.DataFrame()
for sheet in sheet_names:
    df = pd.read_excel(route,sheet_name=sheet)
    # 添加你自己的操作，比如将读取到的表都合并为一张表
    dfs = pd.concat([dfs,df],ignore_index = True)
    pass