根据水果名称和城市,将表格2中的订单号插入到表格1中的批注中去。
表格2如下
表格1如下
解决方法
from openpyxl import Workbook
from openpyxl.comments import Comment
import openpyxl
from openpyxl.utils import get_column_letter
# 导入excel数据
wb = openpyxl.load_workbook("commit.xlsx")
sheet1 = wb['sheet1']
sheet2 = wb['sheet2']
# 找到水果类型所在的列数
def problems(problem_cell):
global order_column
problem=sheet2[problem_cell].value
row1 = sheet1[1]
for cell in row1:
if problem == cell.value:
order_column = get_column_letter(cell.column)
r