【pandas将数据，写入Excel的多个工作簿中--字典数据】20230601星期四：
"""@Project : For_Python_Pro@File : 将数据，写入Excel的多个工作簿中-20230531.py@Author : Administrator@Time : 2023/5/31 22:48@Product : PyCharm"""import osimport pandas as pddef toExcel(da,filepath,name):df = pd.DataFrame(da)if not os.path.exists(filepath):writer = pd.ExcelWriter(filepath)else:writer = pd.ExcelWriter(filepath,mode='a',engine='openpyxl')df.to_excel(writer,sheet_name=name,index=False)# writer.save() # 不用这句话writer.close()dataAll = {'page1':[{'name':'li1','age':12,'addres':'hb1'},{'name':'li2','age':13,'addres':'hb2'},{'name':'li3','age':14,'addres':'hb3'}],'page2':[{'name':'li1','age':12,'addres':'hb1'},{'name':'li2','age':13,'addres':'hb2'},{'name':'li3','age':14,'addres':'hb3'}],'page3':[{'name':'li1','age':12,'addres':'hb1'},{'name':'li2','age':13,'addres':'hb2'},{'name':'li3','age':14,'addres':'hb3'}]}for page in dataAll:toExcel(dataAll.get(page),'./111.xlsx',page)