我有一個(gè)模板文件Template.xlsx。它有 2 張：“每月保費(fèi)”和“每月?lián)p失”然后我創(chuàng)建數(shù)據(jù)框 df。我怎樣才能簡單地將 df 保存到“每月保費(fèi)”表中？我認(rèn)為這樣的東西會(huì)起作用，但它會(huì)創(chuàng)建一個(gè)新的工作表名稱。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貢獻(xiàn)1784條經(jīng)驗(yàn) 獲得超7個(gè)贊
要將數(shù)據(jù)框保存到現(xiàn)有工作表，您必須在 Excel 編寫器中設(shè)置工作表集合。
試試這個(gè)代碼：
###### 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()
輸出
添加回答
舉報(bào)
0/150
提交
取消