Excel tables

Turn a range into a native Excel table with filters and banding

An Excel table is more than styling. It gives the range a name, adds filter dropdowns, bands the rows, and lets formulas refer to columns by name instead of by letter.

jet.write_sheet_arrow(
    df.to_arrow(),
    "table.xlsx",
    tables=[{
        "name": "SalesData",
        "start_row": 1,
        "start_col": 0,
        "style": "TableStyleMedium9",
    }],
)

Sizing

Omitting end_row or end_col, or passing 0, lets Jetxl work the bound out from the DataFrame. A negative number does the same thing.

end_row omitted

Becomes start_row plus the number of data rows.

end_col omitted

Becomes start_col plus the column count, minus one.

Mixing

Each is independent. A fixed end_row with end_col left out pins the height and lets the width follow the data.

start_row and end_row are 1-based, while start_col and end_col are 0-based.

Fields

name · str · required

Unique identifier. Formulas reference the table by this name.

start_row · int · required

1-based first row, normally the header.

start_col · int · required

0-based first column.

end_row · int

Optional. Omit it or pass 0 to size from the data.

end_col · int

Optional. Omit it or pass 0 to size from the data.

display_name · str

Friendlier label shown in Excel’s table tools.

style · str

A built-in Excel table style name.

show_first_column · bool · default: "False"

Bolds the first column.

show_last_column · bool · default: "False"

Bolds the last column.

show_row_stripes · bool · default: "True"

Alternating row shading.

show_column_stripes · bool · default: "False"

Alternating column shading.

show_header_row · bool · default: "True"

Header row with filter dropdowns.

show_totals_row · bool · default: "False"

Adds a totals row at the bottom.

column_names · list[str]

Override the detected column names.

A table missing a required key, such as name, is dropped silently. No error is raised and the rest of the sheet writes normally, so check that the table is present in the output.

Styles

Excel ships three families, named by weight:

Family	Range	Suits
TableStyleLight1 to 21	Subtle	Financial statements, print
TableStyleMedium1 to 28	Balanced	Most reports and dashboards
TableStyleDark1 to 11	High contrast	Executive summaries, highlights

To find a style you like, insert a table in Excel and hover over the style gallery. The names appear in the tooltip, and you can paste one straight into style.

Several tables in one sheet

Give each a distinct name and a non-overlapping range:

tables = [
    {"name": "Sales",   "start_row": 1,  "start_col": 0, "end_row": 10, "end_col": 3,
     "style": "TableStyleMedium9"},
    {"name": "Summary", "start_row": 13, "start_col": 0, "end_row": 16, "end_col": 2,
     "style": "TableStyleLight16"},
]

Ranges must not overlap. Excel rejects a workbook whose tables collide, and the failure surfaces when someone opens the file rather than when you write it.