如何在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_workbookdef 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)