Displaying Google sheet data in Tkinter Treeview using Google API using pygsheet

We can collect the google sheet data in a tabular form by using get_all_values() of Pygsheets library. We will use the option include_tailing_empty=False to remove the blank space available after the last row of data.

First we will authorize and connect to google drive. Then open the required file and then connect to worksheet.

Worksheet data will be collected and one list will be returned ( l1 ).

This list we will use to populate the Treeview window with our data.

You can use the code we have written with video tutorial to collect and display MySQL table data in treeview, since we are using the same structure and data, we will remove the MySQL connections and keep only the layout with structure to add the data taken from Worksheet ( the list l1 )

Copy the code from here and remove the MySQL part from here.

You can check the full code here

Authentication using google API and downloading JSON file with credentials

#goodSheetTreeview #TreeviewWithGoglesheet #dataInTreeview #GoogleSheet #pygsheets #tkinter #plus2net

[ttvtoosmart]

i have some datat where there are two students with same name, and the app gives error due to this duplication, how can i force it to show all data

[rahulnahar]

One more help: Could you please make a video regarding: I want to print a complete application form. Data taken from multiple pages and segregate in one page by clicking print button as well a side a save as pdf button. Student details print application form will be the best example. Because many details like name, father, date of birth, date of admission, parent contact details, upload photo, automatic school stamp seal over the cross photo, email, student contact number, address, district, state, country, pin code etc things need in one page. Please

[tazulislam]

bro i have about 5000 rows of data but treeview display only 1600 rows. why does it not display the rest? Pls reply!