我正在編寫一個 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()
3 回答
慕桂英4014372
TA貢獻1871條經驗 獲得超13個贊
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()
這對我有用
炎炎設計
TA貢獻1808條經驗 獲得超4個贊
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()
慕村9548890
TA貢獻1884條經驗 獲得超4個贊
你試過熊貓嗎？
https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.to_excel.html
簡單如：
df.to_excel(my_dataframe)
添加回答
舉報
0/150
提交
取消