python openpyxl excel重命名列名

直接访问第一行单元格，修改其值。

import openpyxl
from openpyxl import load_workbook

import pandas as pd

excel_file = 'D:/test.xlsx'

wb = openpyxl.load_workbook(excel_file)
ws = wb['Sheet1']

ws['A1'] = '姓名'

ws['B1'] = '年龄'

wb_report.save(excel_file)