各位，有一個表格（sheet1）由于資料量不定（即行數不定），想在表格里資料的末端自動新增一行"訂單總數：","營收總金額(元)：","訂單失敗總數：","處理成功總數"的內容，請教一下如何和實作？
代碼如下：
from openpyxl import load_workbook
import pandas as pd
import numpy as np
from openpyxl.utils.dataframe import dataframe_to_rows
# 寫入資料
datatotal1 = pd.DataFrame(["訂單總數：","營收總金額(元)：","訂單失敗總數：","處理成功總數"])
df.append(datatotal1, ignore_index=True)
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/246289.html