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)