+- 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] Data from Excel GUI (/thread-29393.html)
Data from Excel GUI - maaad - Aug-31-2020
I`m beginner in Python, could you please help to adopt the script above and add my df:
https://python-forum.io/Thread-Tkinter-Python-Tkinter-How-can-I-send-path-Excel-from-GUI-to-scripte?pid=124474#pid124474
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()I need add the script below:df = pd.read_excel(GET EXCEL FILE, header=0, usecols = 'A, B, C', skiprows = 2)GET EXCEL FILE = File from Tkinter.
RE: Data from Excel GUI - Larz60+ - Aug-31-2020
we won't write the code for you. Please make an effort, then ask if you have difficulty.
We ar happy to help with specific problems.