如何让Python在每次运行程序时在excel中添加新行？

pip install openpyxl

import openpyxl

workbook = openpyxl.load_workbook('filename.xlsx')

worksheet = workbook['sheetname']

last_row = worksheet.max_row

new_row = last_row + 1
worksheet.cell(row=new_row, column=1, value='Value1')
worksheet.cell(row=new_row, column=2, value='Value2')

workbook.save('filename.xlsx')

import openpyxl

# 打开Excel文件
workbook = openpyxl.load_workbook('filename.xlsx')

# 选择要操作的工作表
worksheet = workbook['sheetname']

# 获取当前工作表的最后一行
last_row = worksheet.max_row

# 在最后一行的下一行添加新行
new_row = last_row + 1
worksheet.cell(row=new_row, column=1, value='Value1')
worksheet.cell(row=new_row, column=2, value='Value2')

# 保存Excel文件
workbook.save('filename.xlsx')