IXlRow Members

Represents a single row in a worksheet.

Properties

Name Description
Formatting Gets or sets format characteristics of the row.
HeightInPixels Gets or sets the row height in pixels.
HeightInPoints Gets or sets the row height in points.
IsCollapsed Gets or sets a value indicating whether the group related to this summary row is collapsed.
IsHidden Gets or sets whether the row is visible or hidden.
RowIndex Gets the zero-based index of the current row.

Methods

Name Description
ApplyFormatting(XlCellFormatting) Applies the specified formatting settings to the entire row.
BeginTable(IEnumerable<XlTableColumnInfo>, Boolean, XlCellFormatting) Starts generating a table in the worksheet.
BeginTable(IEnumerable<String>, Boolean) Starts generating a table in the worksheet.
BeginTable(IEnumerable<String>, Boolean, XlCellFormatting) Starts generating a table in the worksheet.
BlankCells(Int32, XlCellFormatting) Creates the specified number of empty cells to which specific formatting options are applied.
BulkCells(IEnumerable, XlCellFormatting) Creates cells with the specified values and format characteristics.
CreateCell() Creates a new cell in the row and returns the IXlCell object.
CreateCell(Int32) Creates a new cell at the intersection of the current row and the specified column.
Dispose() Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources. Inherited from IDisposable.
EndTable(IXlTable, Boolean) Finishes table generation after calling the IXlRow.BeginTable method.
SkipCells(Int32) Specifies the number of successive cells to be skipped in the row before starting to create a new cell.
See Also