Format methods

The following table shows the Excel format categories, in the order shown in the Excel “Format Cell” dialog, and the equivalent rust_xlsxwriter Format method. The links will take you to the API docs:

CategoryDescriptionMethod Name
NumberNumeric formatset_num_format()
AlignmentHorizontal alignset_align()
Vertical alignset_align()
Rotationset_rotation()
Text wrapset_text_wrap()
Indentationset_indent()
Reading directionset_reading_direction()
Shrink to fitset_shrink()
FontFont typeset_font_name()
Font sizeset_font_size()
Font colorset_font_color()
Boldset_bold()
Italicset_italic()
Underlineset_underline()
Strikethroughset_font_strikethrough()
Super/Subscriptset_font_script()
BorderCell borderset_border()
Bottom borderset_border_bottom()
Top borderset_border_top()
Left borderset_border_left()
Super/Subscriptset_font_script()
BorderCell borderset_border()
Bottom borderset_border_bottom()
Top borderset_border_top()
Left borderset_border_left()
Right borderset_border_right()
Border colorset_border_color()
Bottom colorset_border_bottom_color()
Top colorset_border_top_color()
Left colorset_border_left_color()
Right colorset_border_right_color()
Diagonal borderset_border_diagonal()
Diagonal border colorset_border_diagonal_color()
Diagonal border typeset_border_diagonal_type()
FillCell patternset_pattern()
Background colorset_background_color()
Foreground colorset_foreground_color()
ProtectionUnlock cellsset_unlocked()
Hide formulasset_hidden()