[Tkinter] Tkinter - I need to read file excel from GUI app to script file - Printable Version +- Python Forum (https://python-forum.io) +-- Forum: Python Coding (https://python-forum.io/forum-7.html) +--- Forum: GUI (https://python-forum.io/forum-10.html) +--- Thread: [Tkinter] Tkinter - I need to read file excel from GUI app to script file (/thread-25984.html) |
Tkinter - I need to read file excel from GUI app to script file - johnjh - Apr-17-2020 I have an app by Tkinter Controll.py this is my code : import os from tkinter import * from tkinter import ttk from tkinter import filedialog root = Tk() root.title("Fisrt") ttk.Label(root, text="Add Excel File :").grid(row=0, column=0, padx=20, pady=20) open_file = ttk.Button(root, text="Open files") open_file.grid(row=0, column=1, columnspan=2, padx=20, pady=20) ttk.Label(root, text="Name Excel :").grid(row=1, column=0, padx=20, pady=20) box_red_path = ttk.Label(root, text="") box_red_path.grid(row=1, column=1, columnspan=4, padx=20, pady=20) stare_scripte = ttk.Button(root, text="Start") stare_scripte.grid(row=3, column=2, columnspan=2, padx=20, pady=20) def upload_excel(): global path filename = filedialog.askopenfilename(title="Select a File", filetype=(("Excel", "*.xlsx"), ("Excel", "*.xls"))) path = filename box_red_path.configure(text=path) print(path) # PATH EXCEL open_file.config(command=upload_excel) def read_excel(): return path # FilePaht def start_app(): print('app running') os.system('python ..\\Tests\\AllTests.py') stare_scripte.config(command=start_app) root.mainloop() Seconde file Data.py : I need to add function to import FilePath and use it in my script: Like change Path = "../Resources/KDP.xlsx" and add Path = FilePath import openpyxl Path = "../Resources/t.xlsx" # EXCEL wb = openpyxl.load_workbook(Path) sheet = wb['sheet'] firstcell = sheet["A2"].value |