Sheet appearance

Presentation settings that apply to the whole sheet rather than any particular cell.

Gridlines and zoom

bool

default:"True"

Hiding gridlines is the single biggest visual difference between a data dump and a designed report.

int

Opening zoom, 10 to 400.

jet.write_sheet_arrow(
    df.to_arrow(), "clean.xlsx",
    gridlines_visible=False,
    zoom_scale=120,
)

Tab colors

str

Hex color on the sheet tab.

Color	Value
Blue	`4472C4`
Green	`00B050`
Red	`FF0000`
Orange	`FFC000`
Purple	`7030A0`

In a multi-sheet workbook, color by role rather than decoratively. Inputs one color, outputs another. It makes a twelve-tab workbook navigable.

Hiding rows and columns

list[int]

0-based column indices.

list[int]

Row indices.

jet.write_sheet_arrow(
    df.to_arrow(), "report.xlsx",
    hidden_columns=[2, 4],
    hidden_rows=[3],
)

Hidden isn’t removed. The values stay in the file and any recipient can unhide them in two clicks. Never hide data you wouldn’t be willing to send. Drop the column from the DataFrame instead.

Right-to-left

bool

default:"False"

Flows the sheet from right to left, for Arabic, Hebrew, Persian and similar.

df = pl.DataFrame({"שם": ["אליס", "בוב"], "גיל": [25, 30]})

jet.write_sheet_arrow(df.to_arrow(), "hebrew.xlsx", right_to_left=True)

This affects layout direction only. Column A moves to the right edge, and Excel renders the text itself according to its own content.

A composed look

jet.write_sheet_arrow(
    df.to_arrow(), "dashboard.xlsx",
    sheet_name="Performance",
    gridlines_visible=False,
    zoom_scale=120,
    tab_color="0070C0",
    default_row_height=20.0,
    styled_headers=True,
    freeze_rows=1,
    auto_width=True,
)

Get started

Guides

Recipes

Reference

About

Sheet appearance

Gridlines and zoom

Tab colors

Hiding rows and columns

Right-to-left

A composed look

​Gridlines and zoom

​Tab colors

​Hiding rows and columns

​Right-to-left

​A composed look

Gridlines and zoom

Tab colors

Hiding rows and columns

Right-to-left

A composed look