如何在django中将不同功能的两个数据框写入一个excel文件

Question

我正在编写一个 Django 应用程序。在该应用程序中，我在视图中有两个功能。在每个函数中，dataframeenter code here将数据写入 excel 文件。但我想将数据写入一个excel文件。但是这样它只存储df数据我想要两个数据帧数据到两张表中def func_one(request):    writer = pd.ExcelWriter(file_path, engine='xlsxwriter')    ad_dataframe.to_excel(writer,'Sheet1',index=False,encoding='utf-8-sig')    writer.save()    writer.close()def func_two(request):    writer = pd.ExcelWriter(file_path, engine='xlsxwriter')    df.to_excel(writer,'Sheet2',index=False,encoding='utf-8-sig')    writer.save()    writer.close()

Answer 1

from openpyxl import load_workbook

def func_one(request):

    writer = pd.ExcelWriter(file_path, engine='xlsxwriter')

    ad_dataframe.to_excel(writer,'Sheet1',index=False,encoding='utf-8-sig')

    writer.save()

    writer.close()

def func_two(request):

    book = load_workbook(file_path)

    writer = pd.ExcelWriter(file_path, engine='openpyxl') 

    writer.book = book

    writer.sheets = dict((ws.title, ws) for ws in book.worksheets)

    ad_dataframe.to_excel(writer, "Sheet2",index=False,encoding='utf-8-sig')

    writer.save()

    writer.close()

这对我有用

Answer 2

dfs = {'Sheet 1':df1, 'Sheet 2':df2}

writer = pd.ExcelWriter(file_path, engine='xlsxwriter')

for sheet_name in dfs.keys():

    dfs[sheet_name].to_excel(writer, sheet_name=sheet_name, index=False)

writer.save()

Answer 3

你试过熊猫吗？

https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.to_excel.html

简单如：

df.to_excel(my_dataframe)