Python中年使用Excel函数

Python中使用Vlookup函数

from openpyxl import load_workbook

workbook = load_workbook(‘xxx.xlsx’)
sheet = workbook[‘sheet1’]
sheet[‘G1’] = ‘名称’
for i in range(2,sheet.max_row+1):
sheet[f’G{i}’] = f’=VLOOKUP(E{i},$k$1:$L$5,2,0)’
workbook.save(filename = ‘xxx.xlsx’)