python读取xlsx表替换指定行、列

from openpyxl import load_workbook
from openpyxl.styles import Alignment
filename = "aa.xlsx"
wb = load_workbook(filename)
ws = wb.active

# 指定行和列
row_num = 10
col_num = 2

# 往指定的单元格插入数据
cell1 = ws.cell(row=row_num, column=col_num, value="2023-06-26")
cell2 = ws.cell(row=row_num, column=3, value="1234565")
cell1.alignment = Alignment(wrap_text=True)  #此处设置自动换行
cell2.alignment = Alignment(wrap_text=True)
# 存储为新文件
new_filename = "new.xlsx"
wb.save(new_filename)

# 关闭文件
wb.close()