Openpyxl tkinter search a value in Excel column

[Heathcliff_1]

Hello,

I am a big beginner in Python, so I hope I will fine a help to resolve my current problem.
Firstly, I am working with Python 3, and I want when the user enter a site ID (format Txxxxx) in ZT1, the program goes to Excel file "My_Excel.xlsx" and search for the site ID in the column "B", and if this value is found, the program should return the value of the Col "I" in ZT2 (of the first row where site ID in Col "B" is found). Kind of Vlookup function.
This is my code to complete:

from tkinter import *
from tkinter import messagebox
import openpyxl
from openpyxl import Workbook
 
def Verification(*args):
   value = ZT1.get()
   if len(value) != 6 or value[:1] != "T" or not value[1:6].isdigit() :
     messagebox.showwarning("Error", "ID not valide")
     ZT1.delete(0,END)
   else :
 
# Put the value of Col "I" in ZT2 (if the ID is found in Col "B" of course)
 
fen = Tk()
fen.state('zoomed')
fen.title('Rapports CCU')
Label1 = Label(fen, text = "N° ID :", font = 'times')
Label1.place(x = 35,y = 16)
 
Label2 = Label(fen, text = "Region :", font = 'times')
Label2.place(x = 268,y = 16)
 
 
ZT1 = Entry(fen, width = 17, justify='center', bg="#aee6ff")
ZT1.place(x = 155, y = 20)
ZT1.bind("<Return>",Verification)
 
ZT2 = Text(fen, width = 13, height=1, bg="#c9d4ff")
ZT2.place(x = 405, y = 20)
ZT2.config (state=DISABLED)
 
wb = openpyxl.load_workbook('My_Excel.xlsx')
ws = wb.active
 
fen.mainloop()

Thanks in advance.

Ragards;

Larz60+ write Dec-02-2020, 06:44 PM:
The tag you should use for multi-line python srcipt is '[python]',
non '[inline]'. I fixed this.
inline is used for a single python statement embedded within a text field.