How to make a drop down from excel values in tkinter? [closed]
Make an empty list, then append each value in the column. Also, be sure you don't use reserved keywords as variables.
Code:
from openpyxl import load_workbookfrom tkinter import *import tkinter.ttk as ttk# Load the xlsx file, then store the value of each column in the "elements" listwb = load_workbook(filename=r"C:\Users\Hp\Desktop\Test data.xlsx")ws = wb['Sheet1']xlsx_range = ws['B2':'B10']elements = []for cell in xlsx_range: for x in cell: y = x.value elements.append(y) print(y)# Tkinter stuffwin = Tk()clicked = StringVar()combodata = ttk.Combobox(win, width=100,state='readonly', values=elements)combodata.pack(pady=20)win.mainloop()