1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36
| 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("Erreur", "Merci de renseigner un ID valide")
ZT1.delete(0,END)
else :
# Mettre la valeur de la colonne "I" dans ZT2
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 = "Région :", 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('Mon_Excel.xlsx')
ws = wb.active
fen.mainloop() |
Partager