<p align="center" width="100%"> <img width="45%" src="https://github.com/user-attachments/assets/4afc1783-6461-4b98-93cb-b2a2a7f35169" alt="tksheet table"> <img width="45%"src="https://github.com/user-attachments/assets/08e77e89-00ea-4c52-9222-9bd421284360" alt="tksheet treeview"> </p>

<div align="center">tksheet - python tkinter table + treeview widget</div>

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.

<table> <thead> <tr> <th style="color: lightgreen" colspan=2><strong>Help</strong></th> </tr> </thead> <tbody> <tr> <td style="color: LightCoral">Versions 6.x.x &#8594;</td> <td><a href="https://github.com/ragardner/tksheet/wiki/Version-6" target="_blank">Documentation</a></td> </tr> <tr> <td style="color: lightgreen">Versions 7.x.x &#8594;</td> <td><a href="https://ragardner.github.io/tksheet/DOCUMENTATION.html" target="_blank">Documentation</a></td> </tr> <tr> <td align="right" colspan="2"><a href="https://github.com/ragardner/tksheet/blob/master/docs/CHANGELOG.md" target="_blank">Changelog</a></td> </tr> <tr> <td align="right" colspan="2"><a href="https://github.com/ragardner/tksheet/wiki/Version-7#issues" target="_blank">Issues</a></td> </tr> <tr> <td align="right" colspan="2"><a href="https://github.com/ragardner/tksheet/wiki/Version-7#contributions-and-special-thanks" target="_blank">Contributions and Thanks</a></td> </tr> </tbody> </table>

Features

• Smoothly display and modify tabular data
• Edit cells directly
• Cell values can potentially be any 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 data
sheet["A1"].data = "edited cell A1"

# get data
column_b = sheet["B"].data

# add 2 empty columns and add the change to undo stack
sheet.insert_columns(columns=2, idx=4, undo=True)

# delete columns 0 and 3 and add the change to undo stack
sheet.delete_columns(columns=[0, 3], undo=True)

light blue theme

dark theme

treeview mode

Changes for versions 7+:

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