Python Forum
[Tkinter] Python - Tkinter : How can I send path Excel from GUI to scripte - Printable Version

+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/Forum-Python-Coding)
+--- Forum: GUI (https://python-forum.io/Forum-GUI)
+--- Thread: [Tkinter] Python - Tkinter : How can I send path Excel from GUI to scripte (/Thread-Tkinter-Python-Tkinter-How-can-I-send-path-Excel-from-GUI-to-scripte)



Python - Tkinter : How can I send path Excel from GUI to scripte - johnjh - Apr-24-2020

Hello Guys I have a script and Now I'm Build Interface in that script:

The Script work by data from Excel:

After upload and click start : I need to send Path Excel to Script meaning to another module have name data.py:

this is my code of GUI Interface Build By Tkinter:

import os
from tkinter import *
from tkinter import ttk
from tkinter import filedialog

root = Tk()
root.title("GUI")
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():

    filename = filedialog.askopenfilename(title="Select a File", filetype=(("Excel", "*.xlsx"), ("Excel", "*.xls")))

    path = filename

    box_red_path.configure(text=path)
open_file.config(command=upload_excel)

def start_app():
    print('app running')

stare_scripte.config(command=start_app)
root.mainloop()
This is my Interface: [Image: DEq2C.png]


RE: Python - Tkinter : How can I send path Excel from GUI to scripte - Larz60+ - Apr-24-2020

The best way (in my opinion) is to contain it all in a class.
then you can expose any variables you wish to other applications that you wish.
I have an example here (large app, but concepts same for small one): https://python-forum.io/Thread-Show-Installed-Package-detail?highlight=tkinter
or this simple one: https://python-forum.io/Thread-Show-all-available-bindings-for-given-widget?highlight=tkinter


RE: Python - Tkinter : How can I send path Excel from GUI to scripte - maaad - Aug-28-2020

johnjh Good job.

I`m beginner in Python, could you please help to adopt the script above and add my df:

df = pd.read_excel(GET EXCEL FILE, header=0, usecols = 'A, B, C', skiprows = 2) 
GET EXCEL FILE = File from Tkinter.