Opening files in a folder with Openpyxl Opening files in a folder with Openpyxl tkinter tkinter

Opening files in a folder with Openpyxl


Just found the answer using this guide

from tkinter import filedialogimport tkinter as tkimport openpyxlimport osroot = tk.Tk()root.withdraw()folder = filedialog.askdirectory()for f in os.listdir(folder):    path = os.path.join(folder,f)    wb = openpyxl.load_workbook(path)    ws = wb.active    v = ws['A1']    print(v.value)