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 [ ]: