Module row 

Row operations for worksheet manipulation.

All functions operate directly on a WorksheetXml structure, keeping the business logic decoupled from the Workbook wrapper.

Functions

duplicate_row

Duplicate a row, inserting the copy directly below the source row.

duplicate_row_to

Duplicate a row to a specific target row number. Existing rows at and below target are shifted down to make room.

get_row_height

Get the height of a row. Returns None if the row does not exist or has no explicit height set.

get_row_outline_level

Get the outline (grouping) level of a row. Returns 0 if not set.

get_row_style

Get the style ID for a row. Returns 0 (default) if the row does not exist or has no explicit style.

get_row_visible

Get the visibility of a row. Returns true if visible (not hidden).

get_rows

Get all rows with their data from a worksheet.

insert_rows

Insert count empty rows starting at start_row, shifting existing rows at and below start_row downward.

remove_row

Remove a single row, shifting rows below it upward by one.

set_row_height

Set the height of a row in points. Creates the row if it does not exist.

set_row_outline_level

Set the outline (grouping) level of a row.

set_row_style

Set the style for an entire row. The style_id is the ID returned by add_style(). Setting a row style applies the s attribute on the row element and marks customFormat so Excel honours it. Existing cells in the row also have their individual style updated.

set_row_visible

Set the visibility of a row. Creates the row if it does not exist.