التحقق من صحة الكود والتعديل عليه رجاءاً

السلام عليكم

معذرة أحتاج تصحيح في هذا الكود حيث أنه لدي أداة القائمة من المفترض عند اختيار الملف تمتلئ هذه القائمة

الرجاء الاطلاع وتشغيل الكود وتصحيح الخطأ الذي به

import customtkinter
from tkinter import filedialog
from pathlib import Path
import pandas as pd

class Frame1(customtkinter.CTkFrame):
    def __init__(self, master):
        super().__init__(master)
        self.AS = None

        def LoadFile():
            filepath = filedialog.askopenfilename(initialdir="C:\\Users\\Cakow\\PycharmProjects\\Main", title="Open file okay?", filetypes=(("text files", "*.xlsx"), ("all files", "*.*")))
            filepathA = Path(filepath)
            self.AS = pd.ExcelFile(filepathA)
            
            AD = self.sht()
		
            self.optionmenu1.values = AD

        self.button1 = customtkinter.CTkButton(self, text="إختيار ملف", font=customtkinter.CTkFont(family="Calibri", size=12, weight="bold"), command=LoadFile)
        self.button1.grid(row=0, column=1, padx=3, pady=(3, 0), sticky="we")

        self.optionmenu1 = customtkinter.CTkOptionMenu(self)
        self.optionmenu1.grid(row=0, column=0, padx=3, pady=(3, 0), sticky="we")

    def sht(self):
        if self.AS:
            AD = self.AS.sheet_names
            return AD
        else:
            return []

class Frame2(customtkinter.CTkFrame):
    def __init__(self, master):
        super().__init__(master)
        self.checkbox_1 = customtkinter.CTkCheckBox(self, text="checkbox 1")
        self.checkbox_1.grid(row=0, column=0, padx=3, pady=(3, 0), sticky="w")

class Frame3(customtkinter.CTkFrame):
    def __init__(self, master):
        super().__init__(master)

        def button_event():
            print("خروج")

        self.button2 = customtkinter.CTkButton(self, text="خروج", state="disabled", font=customtkinter.CTkFont(family="Calibri", size=12, weight="bold"), command=button_event)
        self.button2.grid(row=0, column=0, padx=3, pady=(3, 0), sticky="w")

class App(customtkinter.CTk):
    def __init__(self):
        super().__init__()

        self.title("my app")
        self.geometry("400x180")
        self.grid_columnconfigure(0, weight=1)
        self.grid_rowconfigure(0, weight=1)
        customtkinter.set_appearance_mode("dark")
        customtkinter.set_default_color_theme("dark-blue")

        self.Frame_A = Frame1(self)
        self.Frame_A.grid(row=0, column=0, padx=1, pady=(1, 0), sticky="nswe")
        self.Frame_B = Frame2(self)
        self.Frame_B.grid(row=0, column=1, padx=1, pady=(1, 0), sticky="nswe")
        self.Frame_C = Frame3(self)
        self.Frame_C.grid(row=1, column=0, padx=1, pady=(1, 10), sticky="nswe")

app = App()
app.mainloop()