#Python tkinter treeview headings code

MySQL database table as data source from sqlalchemy import create_enginemy_conn = create_engine('mysql+mysqldb:// userid: localhost/ my_db')r_set=my_conn.execute('SELECT * FROM student')l1= # List of column headers #l1=

Tkinter Treeview displaying data rows with headers from different source like CSV file & Excel Note that souce can be SQLite or Excel or Pandas DataFrame or any other source.Ĭreating the Treeview trv = ttk.Treeview(my_w, selectmode ='browse')trv.grid(row=1,column=1,padx=30,pady=20)

#Python tkinter treeview headings code

We will replace the list l1 in above code with our data column headers and for that we have used our MySQL table. l1= Using this list we will add our columns and headers ( list elements ) to our Treeview. We can replace our list with data from Database table. This way we will not have any fixed number of columns and based on the source or data, we have to create the columns.įor our easy understanding let us create one list and use the elements as column headers.

The third query will return all the columns of the student table. Here are some SQL which collects different number of columns from the table SELECT id,name FROM student SELECT id,name,class FROM studentSELECT * FROM studentFirst and second query will collect two and three columns respectively from our student table. Sample data from different Data Sources Sample data in Excel, CSV, MySQL dump, SQLite databae, Pandas DataFrame → Number of columns to displayWhen we collect data from the source ( database table or Excel or CSV file ) we are not sure how many columns will be available.