I'm using openpyxl to manipulate some spreadsheets. I have this code to match values between two sheets on Excel, if the values match it updates a cell in that row:
for cell in ws1['a']: for num in ws4['a']: if cell.value == num.value: ws1.cell(row=cell.row, column=23).value = ws4.cell(row=num.row, column=9).value
There are 10000 rows of data on each sheet. This task takes a couple minutes to complete. Is there a faster way to do this?