我正在嘗試將 df 值匯出到 excel 檔案而不影響其他作業表。但上面的代碼是創建一個新作業表而不是替換現有作業表。有人可以幫忙嗎？
這是我的代碼
import pandas as pd
import openpyxl
df1 = pd.read_excel(r'D:\FY 22 - 23\Apr - 22\Daily Sales\Daily_level_data.xlsx',sheet_name = 'test')
with pd.ExcelWriter(r'D:\FY 22 - 23\Apr - 22\Daily Sales\Daily Sales Master_test.xlsx', mode="a",
engine="openpyxl", on_sheet_exists ="replace") as writer:
df1.to_excel(writer, sheet_name="Day_level")
print('data imported in daily sales master - sucessfully')
uj5u.com熱心網友回復：
看看檔案，應該if_sheet_exists不是on_sheet_exists。但是，它仍然無法正常作業。
您可以使用 writer.sheets 將作業表傳遞給作者。有點煩人，但它有效：
import pandas as pd
import openpyxl
book = openpyxl.load_workbook(r'D:\FY 22 - 23\Apr - 22\Daily Sales\Daily Sales Master_test1.xlsx')
df1 = pd.read_excel(r'D:\FY 22 - 23\Apr - 22\Daily Sales\Daily_level_data.xlsx',sheet_name = 'test')
with pd.ExcelWriter(r'D:\FY 22 - 23\Apr - 22\Daily Sales\Daily Sales Master_test1.xlsx', mode="a",
engine="openpyxl", ) as writer:
writer.book = book
writer.sheets = {ws.title:ws for ws in book.worksheets}
df1.to_excel(writer, sheet_name="Day_level")
print('data imported in daily sales master - sucessfully')
轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/455048.html
上一篇：在輸入欄位中放置兩個圖示