Combobox options from Google Sheets

import pygsheets
path='G:\\My drive\\testing\\google-sheet\\creds1.json'
gc=pygsheets.authorize(service_account_file=path)
sh=gc.open('my_gsheets1') 
wk1=sh[0]
#collect data from first column 2nd row to 7th row
l1=wk1.get_values('A2','A7') # create a list using range
#print(*l1) # testing our list 

### Use the list l1 as options of Combobox : Part II #
import tkinter as tk
from tkinter import ttk
my_w = tk.Tk()
my_w.geometry("150x150")  # Size of the window 
my_w.title("www.plus2net.com")  # Adding a title

cb1 = ttk.Combobox(my_w, values=l1,width=7) # Combobox
cb1.grid(row=1,column=1,padx=10,pady=20) # adding to grid

cb1.set('King') # default selected option
my_w.mainloop()  # Keep the window open

Subhendu Mohapatra

Author

🎥 Join me live on YouTube

Passionate about coding and teaching, I publish practical tutorials on PHP, Python, JavaScript, SQL, and web development. My goal is to make learning simple, engaging, and project‑oriented with real examples and source code.

← Subscribe to our YouTube Channel here