Tableview of ttkbootstrap

Example withe list of columns and data rows
Summary row : Adding extra record by insert_row()
Paging of reocrds
Pagesize & height
Updating default font
Summary row and paging of records
Export Rows
Export selected Rows
Getting row value
Delete Row
Hide and show column by Checkbutton


`bootstyle`	Style keyword, options are primary, secondary, success,info,warning,danger, light, dark
`coldata`	Names or Dictionary of column names with settings.
`rowdata`	Iterable rows with data. Must match with number of columns
`paginated`	Adding Pagination of records - required or not. ( True / False )
`pagesize`	Number of rows to show per page, works with paginated check the difference between pagesize and height below.
`searchable`	Show search entry or not
`autofit`	If True, columns will be automatically sized.
`autoalign`	If True, Numbers are right aligned and others are left aligned.
`stripecolor`	Tuple to provide alternate row colours. ('lightblue',None)
`height`	Number of rows to display in Viewport. Check below for details.
`delimiter`	Char to use as delimiter ( default is comma ) while esporting data.

Ttkbootstrap tableview to display tabular data with parameters to manage properties

Example with List of Columns and data Rows 🔝

Here we are creating two different Lists. The list l1 is the column header text with dictionay of style properties.
One more list r_set contains the rows of data.
We can change the parameters of the table and observe the effects.

import ttkbootstrap as ttk
from ttkbootstrap.tableview import Tableview
from ttkbootstrap.constants import *

my_w = ttk.Window()
my_w.geometry("400x300")  # width and height
colors = my_w.style.colors
l1 = [
    {"text": "id", "stretch": False},
    {"text":"Name","stretch":True},
    "Class",
    {"text":"Mark"},
    {"text":"Gender"}
]  # Columns with Names and style 
# Data rows as list 
r_set = [(1, "Alex", 'Four',90,'Female'), (2, "Ron", "Five",80,'Male'), 
            (3, "Geek", 'Four',70,'Male'),(4,'King','Five',78,'Female'),
            (5,'Queen','Four',60,'Female'),(6,'Jack','Five',70,'Female')]

dv = ttk.tableview.Tableview(
    master=my_w,
    paginated=True,
    coldata=l1,
    rowdata=r_set,
    searchable=True,
    bootstyle=SUCCESS,
    pagesize=10,
    height=10,
    stripecolor=(colors.light, None),
)
dv.grid(row=0, column=0, padx=10, pady=5)
dv.autofit_columns() # Fit in current view 
my_w.mainloop()

Summary row: Adding extra record by insert_row() 🔝

Summary row showing sum of marks at end of Tableview of Tkinter ttkbootstrap

After the table is displayed we can add one new row at the end of the table showing the summary of data. Here we are showing the total of the mark column values. To get the total value we have used this code.

marks=[r[3] for r in r_set] # List of all marks column
print(sum(marks)) # sum of the marks column

After the table is added we have used insert_row() to add the row at the end and used load_table_data() to load all records to table view.
Ttkboostrap Table with summary row at end

Ttkboostrap Table with summary row at end

Full code is here

import ttkbootstrap as ttk
from ttkbootstrap.tableview import Tableview
from ttkbootstrap.constants import *

my_w = ttk.Window()
my_w.geometry("400x300")  # width and height
colors = my_w.style.colors
l1 = [
    {"text": "id", "stretch": False},
    {"text":"Name","stretch":True},
    "Class",
    {"text":"Mark"},
    {"text":"Gender"}
]  # Columns with Names and style 
# Data rows as list 
r_set = [(1, "Alex", 'Four',90,'Female'), (2, "Ron", "Five",80,'Male'), 
            (3, "Geek", 'Four',70,'Male'),(4,'King','Five',78,'Female'),
            (5,'Queen','Four',60,'Female'),(6,'Jack','Five',70,'Female')]
marks=[r[3] for r in r_set] # List of all marks column
print(sum(marks)) # sum of the marks column 
dv = ttk.tableview.Tableview(
    master=my_w,
    paginated=True,
    coldata=l1,
    rowdata=r_set,
    searchable=True,
    bootstyle=SUCCESS,
    pagesize=10,
    height=10,
    stripecolor=(colors.light, None),
)
dv.grid(row=0, column=0, padx=10, pady=5)
dv.autofit_columns() # Fit in current view 
dv.insert_row("end", values=['-', "---", "All", sum(marks), "All"])
dv.load_table_data() # Load all data rows 
my_w.mainloop()

We can add column and rows after initialization of the table

dv.build_table_data(l1,r_set)
dv.autofit_columns() # Fit in current view 
dv.load_table_data() # Load all data rows

Paging of records 🔝

If we have large number of rows and the view port ( height parameter ) is less, then we can display some records within the view port and provide user with navigation to move to different part of the available records.
Read more about PHP Paging here .
By making the parameter paginated=True , we can show navigation buttons to move to different pages of the records. Here the parameter pagesize=10 will accommodate 10 records per page.

pagesize & height 🔝

Pagesize: number of records visible per page.
height : number of rows within Table's viewport.

If Pagesize is more than height then user has to scroll using mousewheel to naviage.

Updating default font 🔝

Use these lines after declaring the root window to change the font details.

from tkinter.font import nametofont
default_font = nametofont("TkDefaultFont")
default_font.configure(family="Times",size=14,weight='bold')

Summary row and paging of records 🔝

If we are adding any row by using insert_row() as explained above and using paginated=True then the row will be added at the last page only.

Export Rows 🔝

Right click on the table rows and we can export data using the set delimiter.
By default we can download data as CSV file.
Exporting records in Tableview

Export selectd Rows 🔝

We can use export_current_selection() to export the selected rows to CSV file. Hold the Ctrl key to select multiple rows.

b1=ttk.Button(my_w,text='Export',bootstyle=SUCCESS,
    command=lambda:dv.export_current_selection())
b1.grid(row=1,column=0)

Getting row value 🔝

row = dv.tablerows
print(row[1].values) # [2, 'Max Ruin', 'Three', 85, 'male']

Delete row 🔝

b1=ttk.Button(my_w,text='Export',bootstyle=SUCCESS,
    command=lambda:dv.delete_row(5))

Hide and show a column of table view by using checkbutton 🔝

Show or hide column by using checkbutton in a Tkinter ttkbootstrap tableview

import ttkbootstrap as ttk
from ttkbootstrap.tableview import Tableview
from ttkbootstrap.constants import *

my_w = ttk.Window()
my_w.geometry("400x350")  # width and height
colors = my_w.style.colors
l1 = [
    {"text": "id", "stretch": False},
    {"text":"Name","stretch":True},
    "Class",
    {"text":"Mark"},
    {"text":"Gender"}
]  # Columns with Names and style 
# Data rows as list 
r_set1 = [(1, "Alex", 'Four',90,'Female'), (2, "Ron", "Five",80,'Male'), 
            (3, "Geek", 'Four',70,'Male'),(4,'King','Five',78,'Female'),
            (5,'Queen','Four',60,'Female'),(6,'Jack','Five',70,'Female')]
l2 = [
    {"text": "id", "stretch": False},
    {"text":"Name","stretch":True},
    "Class",
    {"text":"Mark"}
    
]  # Columns with Names and style 
# Data rows as list 
r_set2 = [(1, "Alex", 'Four',90), (2, "Ron", "Five",80), 
            (3, "Geek", 'Four',70),(4,'King','Five',78),
            (5,'Queen','Four',60),(6,'Jack','Five',70)]
dv = ttk.tableview.Tableview(
    master=my_w,
    paginated=True,
    coldata=l1,
    rowdata=r_set1,
    searchable=True,
    bootstyle=SUCCESS,
    pagesize=10,
    height=10,
    stripecolor=(colors.light, None),
)
dv.grid(row=0, column=0, padx=10, pady=5)
#dv.build_table_data(l2,r_set2)
dv.autofit_columns() # Fit in current view 
def my_upd():

    dv.grid_forget()
    if cb1_v.get():
        dv.build_table_data(l1,r_set1)
    else:
        dv.build_table_data(l2,r_set2)
    dv.autofit_columns() # Fit in current view 
    dv.load_table_data() # Load all data rows 
    dv.grid(row=0, column=0, padx=10, pady=5)
cb1_v = ttk.BooleanVar(value=True)
cb1 = ttk.Checkbutton(variable=cb1_v,text="Gender", 
	onvalue=True, offvalue=False, bootstyle=SUCCESS ,command=my_upd)
cb1.grid(row=1,column=0)

my_w.mainloop()

Different data sources for Tableview
ttkbootstrap

Python Tkinter Dictionary Python- Tutorials

Subscribe to our YouTube Channel here