新增、修改数据

from openpyxl import Workbook , load_workbook

wb = Workbook()

ws = wb.active

ws.title = 'qq'

#新增、修改数据

ws['A1'].value = '测试'

ws.append([123,456,789,0])

ws.append([123,456,77,0])

ws.append([123,44,789,14])

wb.save('newexcel.xlsx')