openpyxl写excel

import openpyxl


wb = openpyxl.load_workbook(r"C:\Users\Administrator\PycharmProjects\zhandian_jiekou\data\a1.xlsx")
ws = wb.worksheets[0]
ws.cell(row=1,column=3,value='aaaa')
wb.save(r"C:\Users\Administrator\PycharmProjects\zhandian_jiekou\data\a1.xlsx")

 

ws.cell(row=1,column=3,value='aaaa')

row行，column列

在第1行，第3列的单元格写入数据aaaa