python-find-cell-in-two-different-excel.py

import xlsxwriter
from xlsxwriter.utility import xl_rowcol_to_cell
import xlrd    

hepsiburadaFiyat= r'C:\Users\xxx\Desktop\hepsiburada-fiyat.xlsx'
hepsiburadaSablon= r'C:\Users\xxx\Desktop\hepsiburada-sablon.xlsx'

wbk = xlsxwriter.Workbook('hepsiburada-sablon2.xlsx')
wks = wbk.add_worksheet()

for fiyat in xlrd.open_workbook(hepsiburadaFiyat).sheets():  
    for fiyatSatir in range(fiyat.nrows):
        barkod = fiyat.cell(fiyatSatir, 0)
        fiyatEtiketi = fiyat.cell(fiyatSatir, 1)
        for sablon in xlrd.open_workbook(hepsiburadaSablon).sheets():  
            for sablonSatir in range(sablon.nrows):
                sablonBarkod = sablon.cell(sablonSatir, 1)
                if sablonBarkod.value == barkod.value:
                    findedCell = xl_rowcol_to_cell(sablonSatir, 1)
                    changingCell = xl_rowcol_to_cell(sablonSatir, 5)
                    print(findedCell)
                    wks.write(changingCell, fiyatEtiketi.value)

wbk.close()
print("Program sonlandi")