Repository files navigation

With apologies, development of this library has ceased except for bug fixes or behavioral issues. Pull requests for other changes are unlikely to be merged.

• Smoothly display and modify tabular data
• Edit cells directly
• Cell values can potentially beany class, the default is any class with a__str__ method
• Drag and drop columns and rows
• Editable Treeview mode with working drag and drop, undo, etc.
• Multiple line header and index cells
• Expand row heights and column widths
• Change fonts and font size (not for individual cells)
• Change any colors in the sheet
• Dropdown boxes
• Check boxes
• Progress bars
• Hide rows and/or columns
• Left"w", Center"center" or Right"e" text alignment for any cell/row/column
• In-built natural sorting
• Optional built-in find window

Note that due to the limitations of the Tkinter Canvas right-to-left (RTL) languages are not supported.

"""Versions 7+ have succinct and easy to read syntax:"""# set datasheet["A1"].data="edited cell A1"# get datacolumn_b=sheet["B"].data# add 2 empty columns and add the change to undo stacksheet.insert_columns(columns=2,idx=4,undo=True)# delete columns 0 and 3 and add the change to undo stacksheet.delete_columns(columns=[0,3],undo=True)

• ALLextra_bindings() event objects have changed, informationhere.
• The bound function forextra_bindings() with"edit_cell"/"end_edit_cell"no longer requires a return value and no longer sets the cell to the return value. Usethis instead.
• edit_cell_validation has been removed and replaced with the functionedit_validation(), informationhere.
• Only Python versions >=3.8 are supported.
• tksheet file names have been changed.
• Many other smaller changes, see thechangelog for more information.