buscar_prov



In [1]:
from openpyxl import load_workbook
from openpyxl import Workbook

In [2]:
wb_ant = load_workbook('lista antigua.xlsx', read_only=True)
wb_new = load_workbook('lista sap.xlsx', read_only=True)

In [3]:
ws_ant = wb_ant[wb_ant.sheetnames[0]]

In [5]:
ws_new = wb_new[wb_new.sheetnames[0]]

In [6]:
lista_ant = []
for row in ws_ant.rows :
    cell = row[0]
    lista_ant.append(cell.value)

In [8]:
lista_new = []
for row in ws_new.rows :
    cell = row[0]
    lista_new.append(cell.value)

In [ ]:
for name in

In [ ]: