python 同时写入多个sheet表

ExcelWriter与df.to_excel()的区别

df会覆盖而ExcelWriter不会

dfs = pd.read_excel(air_file, sheet_name=None, skiprows=3)
with pd.ExcelWriter(res_file, engine='openpyxl') as writer:
    for sname, scont in dfs.items():
        if sname in sheet_list:
            scont = scont.filter(items=col_list).fillna("")
            scont.to_excel(writer, sheet_name=sname, index=False)