Skip to end of metadata
Go to start of metadata

Description

The RowProperties class represents a single row in a worksheet. To return a RowProperties object, use Worksheet.GetRowProperties.

C#
vb.net

Examples

C#
vb.net

Properties

Name

Description

Height

Sets or returns the height of the row in points (1/72 of an inch).

Hidden

Sets or returns whether or not the row will be hidden when the workbook is opened in Excel.

OutlineCollapsed

Sets or returns whether the row's outlined row group is collapsed. If the outline is collapsed, the row is hidden.

OutlineLevel

Sets or returns the outline level of the row, as a value between 0 and 7. The outline level is used to control grouping in Excel. For example, to group several rows, set their outline levels to 1; to group a subset of rows within the group, set their outline levels to 2.

RowNumber

Returns the row's 0-based index.

Style

Sets or returns a Style object that determines how cells in the row look, including number format, font, orientation, etc. Accessing this style will not affect the formatting of other cells with the same global style.

Methods

Name

Description

ApplyStyle(Style)

Applies a style to the row.

AutoFitHeight()

Sets the width of the row to the height of the tallest cell value in the row.
  • No labels