file_path = 'data.xlsx'
writer = pd.ExcelWriter(file_path)
for i in range(5):
sh = 'sheet{}'.format(i)
df = pd.pd.DataFrame(data)# 假设这里每次更新不同的df
df.to_excel(writer,sheet_name=sh)
writer.save()
pandas循环写入多个sheet
最新推荐文章于 2023-10-18 20:18:04 发布