修改已有的excel数据

def write_data(data):
import openpyxl
try:
workbook = openpyxl.load_workbook(“test.xlsx”)
except Exception as e:

    workbook = openpyxl.Workbook()
    worksheet = workbook.active
    worksheet.title = "test.xlsx"
    worksheet.append(["关键字", "页码", "排名", "url"])

worksheet = workbook.worksheets[0]
worksheet.append(data)
workbook.save(filename="test.xlsx")