我有一個模板文件Template.xlsx。它有 2 張：“每月保費”和“每月損失”然后我創建數據框 df。我怎樣才能簡單地將 df 保存到“每月保費”表中？我認為這樣的東西會起作用，但它會創建一個新的工作表名稱。import pandas as pdfrom openpyxl import load_workbook#sample dfdf = pd.DataFrame()df["A"] = [1,2,3,4,5]df["B"] = ["A", "B", "C", "D", "E"]#print(df)path = r'C:\My\Path\Template1.xlsx'book = load_workbook(path)writer = pd.ExcelWriter(path, engine='openpyxl')writer.book = bookdf.to_excel(writer, sheet_name='Monthly Premium')writer.save()writer.close()
1 回答
嚕嚕噠
TA貢獻1784條經驗 獲得超7個贊
要將數據框保存到現有工作表，您必須在 Excel 編寫器中設置工作表集合。
試試這個代碼：
###### create test file ######
from openpyxl import load_workbook, Workbook
wb = Workbook()
ws = wb.active
ws.title='Monthly Premium' # rename default sheet
ws = wb.create_sheet('Monthly Losses') # add sheet
wb.save(r'Template1.xlsx')
######### main script #########
import pandas as pd
from openpyxl import load_workbook
#sample df
df = pd.DataFrame()
df["A"] = [1,2,3,4,5]
df["B"] = ["A", "B", "C", "D", "E"]
#print(df)
path = r'Template1.xlsx'
book = load_workbook(path)
writer = pd.ExcelWriter(path, engine='openpyxl')
writer.book = book
writer.sheets = dict((ws.title, ws) for ws in book.worksheets) # prevent new sheet
df.to_excel(writer, sheet_name='Monthly Premium')
writer.save()
writer.close()
輸出
添加回答
舉報
0/150
提交
取消