Pandas用ExcelWriter保存重复的excel工作表

import pandas as pd
from pandas import ExcelWriter

writer = ExcelWriter('output.xlsx')

data = {'Sheet1': df1, 'Sheet2': df2, 'Sheet3': df3}

for sheet_name, df in data.items():
    df.to_excel(writer, sheet_name=sheet_name, index=False)

writer.save()

import pandas as pd
from pandas import ExcelWriter

# 创建ExcelWriter对象
writer = ExcelWriter('output.xlsx')

# 准备要保存的数据
df1 = pd.DataFrame({'Column1': [1, 2, 3]})
df2 = pd.DataFrame({'Column2': ['A', 'B', 'C']})
df3 = pd.DataFrame({'Column3': [True, False, True]})
data = {'Sheet1': df1, 'Sheet2': df2, 'Sheet3': df3}

# 将数据写入Excel文件
for sheet_name, df in data.items():
    df.to_excel(writer, sheet_name=sheet_name, index=False)

# 保存Excel文件
writer.save()