Skip to main content
The shapes below are the TypedDict definitions from jetxl.pyi. Your editor completes them if you type-annotate.

​
Colors

Give six or eight hex digits, with or without a leading #. Jetxl adds an opaque FF alpha to six-digit values. Chart text colors accept the same forms, but Jetxl drops the alpha from eight-digit values. Unusable values are omitted rather than raising an error. See Conventions.

​
Indexing

​
Styling

​
FontStyle

​
bool
​
bool
​
bool
​
float
Points.
​
str
Hex color.
​
str
Typeface.

​
FillStyle

​
"solid" | "gray125" | "none"
​
str
Hex color.
​
str
Hex color.

​
BorderSide

​
"thin" | "medium" | "thick" | "double" | "dotted" | "dashed"
​
str
Hex color.

​
BorderStyle

​
BorderSide
​
BorderSide
​
BorderSide
​
BorderSide

​
AlignmentStyle

​
"left" | "center" | "right" | "justify"
​
"top" | "center" | "bottom"
​
bool
​
int
0 to 180 degrees, or 255 for vertical.

​
CellStyle

​
FontStyle
​
FillStyle
​
BorderStyle
​
AlignmentStyle
​
NumberFormat

​
CellStyleMap

CellStyle plus a position. This is what cell_styles takes.
​
int
1-based.
​
int
0-based.
The stub annotates cell_styles as List[CellStyleMap] on write_sheet_arrow but as List[CellStyleDict] on write_sheet_arrow_to_bytes, and CellStyleDict has no definition in the file. The runtime behavior is the same; only the annotation differs.

​
Validation

All three share start_row, start_col, end_row, end_col, show_dropdown, error_title and error_message.
​
TypedDict
​
TypedDict
​
TypedDict

​
Conditional formatting

All four share the four range keys, plus an optional priority (default 1) and an optional style. Omitting style gives bold red text. Color scales and data bars ignore style.
An unrecognized rule_type causes the rule to be dropped silently rather than raising.
​
TypedDict
​
TypedDict
​
TypedDict
​
TypedDict

​
ExcelTable

​
str
required
​
int
required
1-based.
​
int
required
0-based.
​
int
Optional. Omit it or pass 0 to size from the data.
​
int
Optional. Omit it or pass 0 to size from the data.
​
str
​
str
​
bool
​
bool
​
bool
Default True.
​
bool
​
bool
Default True.
​
bool
Default False.
​
list[str]

​
ExcelChart

​
"column" | "bar" | "line" | "pie" | "scatter" | "area"
required
​
tuple[int, int, int, int]
Alternative to the four range keys.
​
int
Data range.
​
int
Chart position.
​
str
​
int
0-based x-axis column.
​
list[str]
​
bool
​
"right" | "left" | "top" | "bottom" | "none"
​
str
​
str
​
bool
​
bool
Values run 0.0 to 1.0.
​
bool
​
int
1 to 48 legacy, 101 to 148 modern with a value - 100 fallback.
​
float
​
float
​
bool
​
int
Hundredths of a point.
​
str
Hex color. Eight-digit values have the alpha dropped.

​
ExcelImage

Either shape is accepted.
​
TypedDict
​
TypedDict

​
NumberFormat

Sixteen built-in names, or any Excel format code as a string. See Number formats.