各位，有一個表格（sheet1）由于資料量不定（即行數不定），想在表格里資料的末端自動新增一行"訂單總數：","營收總金額(元)：","訂單失敗總數：","處理成功總數"的內容，請教一下如何和實作？
代碼如下：
from openpyxl import load_workbook
import pandas as pd
import numpy as np
from openpyxl.utils.dataframe import dataframe_to_rows
# 寫入資料
data1 = df['訂單號'].count()
data2 = np.sum(df['實際支付價格'])
data3 = np.sum(([df['訂單狀態']=='已退款'],[df['訂單狀態']=='處理失敗']]))
data4 = np.sum(([df['訂單狀態']=='處理成功']))
datatotal1 = pd.DataFrame(["訂單總數：","營收總金額(元)：","訂單失敗總數：","處理成功總數"])
df.loc[0] = [data1,data2,data3,data4]
df.to_excel(writer, sheet_name='sheet1', startcol=0, startrow=0, index=False, header=True)
wbsheet = book['sheet1']
namelist = 'sheet1'
writer.save()
轉載請註明出處，本文鏈接：https://www.uj5u.com/qita/247399.html