Python Forum

Full Version: Tkinter - I need to read file excel from GUI app to script file
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
I have an app by Tkinter this is my code :

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

root = Tk()
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
print(path) # PATH EXCEL


def read_excel():
    return path # FilePaht

def start_app():
    print('app running')
    os.system('python ..\\Tests\\')


Seconde file :

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