import pandas as pd 直接生成Excel df.to_excel(filename) 生成的同时修改sheet名称 df.to_excel(filename,sheet_name='sample') 多个dataframe写入一个文件 with pd.ExcelWriter('stocks.xlsx') as writer: df1.to_excel(writer, sheet_name='df1') df2.to_excel(writer, sheet_name='df2') pass