https://blog.csdn.net/sinat_28576553/article/details/81275650
from openpyxl import load_workbook
excel=load_workbook('tt.xlsx')
table1 = excel.get_sheet_by_name('Table 1') #通过表名获取
table2 = excel.get_sheet_by_name('Sheet1')
#获取行数和列数:
rows1=table1.max_row #获取行数
cols1=table1.max_column #获取列数
rows2=table2.max_row #获取行数
cols2=table2.max_column #获取列数
#获取单元格值:
print(rows,cols)
l1=[]
l2=[]
l3=[]
for i in range(0, rows1):
Data=table1.cell(row=i+1,column=2).value
l1.append(Data)
#print(l1)
for i in range(0, rows2):
Data1=table2.cell(row=i+1,column=2).value
l2.append(Data1)
Data2=table2.cell(row=i+1,column=7).value
l3.append(Data2)
#print(l3)
for i in range(0, rows1):
for j in range(0, rows2):
if(l1[i]==l2[j]):
#print(l3[j])
table1.cell(row=i+1, column=13).value = l3[j]
excel.save('tt.xlsx')