Class Row

Represents a row in a worksheet.

Inheritance

object

AbstractFormattable

Row

Inherited Members

AbstractFormattable.Alignment

AbstractFormattable.Fill

AbstractFormattable.Font

AbstractFormattable.Format

AbstractFormattable.IsLocked

AbstractFormattable.IsFormulaHidden

AbstractFormattable.QuotePrefix

AbstractFormattable.Borders

AbstractFormattable.Style

AbstractFormattable.Worksheet

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

Namespace: DRIT.Spreadsheet

Assembly: DRIT.Spreadsheet.dll

Syntax

public class Row : AbstractFormattable

Remarks

A Row represents a horizontal collection of cells in a worksheet. Rows can have custom height, visibility settings, and formatting applied.

Rows are accessed through the Rows collection.

Examples

// Access and format a row
var row = worksheet.Rows[0]; // First row
row.Height = 25.0;
row.IsHidden = false;

Properties

Address

Adds the supplied ress to the Row.

Declaration

public CellAddress Address { get; }

Property Value

Type	Description
CellAddress	The address returned by the operation.

Remarks

A Row represents a horizontal collection of cells in a worksheet. Rows can have custom height, visibility settings, and formatting applied.

Rows are accessed through the Rows collection.

Cells

Returns a cell-index accessor for this row. Usage: row.Cells[columnIndex]

Declaration

public RowCellsAccessor Cells { get; }

Property Value

Type	Description
RowCellsAccessor

Remarks

A Row represents a horizontal collection of cells in a worksheet. Rows can have custom height, visibility settings, and formatting applied.

Rows are accessed through the Rows collection.

Count

Reports the number of items currently held by Row.

Declaration

public int Count { get; }

Property Value

Type	Description
int	The count returned by the operation.

Remarks

A Row represents a horizontal collection of cells in a worksheet. Rows can have custom height, visibility settings, and formatting applied.

Rows are accessed through the Rows collection.

CustomFormat

Exposes the custom format associated with Row.

Declaration

public bool CustomFormat { get; set; }

Property Value

Type	Description
bool	The custom format returned by the operation.

Remarks

A Row represents a horizontal collection of cells in a worksheet. Rows can have custom height, visibility settings, and formatting applied.

Rows are accessed through the Rows collection.

CustomHeight

Gets the custom height set for the row.

Declaration

public double? CustomHeight { get; }

Property Value

Type	Description
double?	Null is custom height is not set.

Remarks

A Row represents a horizontal collection of cells in a worksheet. Rows can have custom height, visibility settings, and formatting applied.

Rows are accessed through the Rows collection.

FullLabel

Exposes the full label associated with Row.

Declaration

public string FullLabel { get; }

Property Value

Type	Description
string	The full label returned by the operation.

Remarks

A Row represents a horizontal collection of cells in a worksheet. Rows can have custom height, visibility settings, and formatting applied.

Rows are accessed through the Rows collection.

HeightPixels

Specifies the height of the row in pixels.

Declaration

public double HeightPixels { get; set; }

Property Value

Type	Description
double

Remarks

A Row represents a horizontal collection of cells in a worksheet. Rows can have custom height, visibility settings, and formatting applied.

Rows are accessed through the Rows collection.

HeightPoints

Get or set the declared height of the row. If the value is null, the actual height will be the default row height of the sheet.

Declaration

public double HeightPoints { get; set; }

Property Value

Type	Description
double

Remarks

A Row represents a horizontal collection of cells in a worksheet. Rows can have custom height, visibility settings, and formatting applied.

Rows are accessed through the Rows collection.

Index

Exposes the index associated with Row.

Declaration

public int Index { get; }

Property Value

Type	Description
int	The index returned by the operation.

Remarks

A Row represents a horizontal collection of cells in a worksheet. Rows can have custom height, visibility settings, and formatting applied.

Rows are accessed through the Rows collection.

IsCollapsed

Gets or sets whether the dimension is collapsed.

Declaration

public bool IsCollapsed { get; set; }

Property Value

Type	Description
bool

Remarks

A Row represents a horizontal collection of cells in a worksheet. Rows can have custom height, visibility settings, and formatting applied.

Rows are accessed through the Rows collection.

IsHidden

Indicates whether the hidden condition is true for the Row.

Declaration

public bool IsHidden { get; set; }

Property Value

Type	Description
bool	The is hidden returned by the operation.

Remarks

A Row represents a horizontal collection of cells in a worksheet. Rows can have custom height, visibility settings, and formatting applied.

Rows are accessed through the Rows collection.

IsSelected

Indicates whether the selected condition is true for the Row.

Declaration

public bool IsSelected { get; }

Property Value

Type	Description
bool	The is selected returned by the operation.

Remarks

A Row represents a horizontal collection of cells in a worksheet. Rows can have custom height, visibility settings, and formatting applied.

Rows are accessed through the Rows collection.

Label

Exposes the label associated with Row.

Declaration

public string Label { get; }

Property Value

Type	Description
string	The label returned by the operation.

Remarks

A Row represents a horizontal collection of cells in a worksheet. Rows can have custom height, visibility settings, and formatting applied.

Rows are accessed through the Rows collection.

OutlineLevel

Specifies the outline level of the row/ group.

Declaration

public int OutlineLevel { get; set; }

Property Value

Type	Description
int

Remarks

A Row represents a horizontal collection of cells in a worksheet. Rows can have custom height, visibility settings, and formatting applied.

Rows are accessed through the Rows collection.

ShowPhonetic

Exposes the show phonetic associated with Row.

Declaration

public bool ShowPhonetic { get; set; }

Property Value

Type	Description
bool	The show phonetic returned by the operation.

Remarks

A Row represents a horizontal collection of cells in a worksheet. Rows can have custom height, visibility settings, and formatting applied.

Rows are accessed through the Rows collection.

ThickBottom

Exposes the thick bottom associated with Row.

Declaration

public bool ThickBottom { get; set; }

Property Value

Type	Description
bool	The thick bottom returned by the operation.

Remarks

A Row represents a horizontal collection of cells in a worksheet. Rows can have custom height, visibility settings, and formatting applied.

Rows are accessed through the Rows collection.

ThickTop

Exposes the thick top associated with Row.

Declaration

public bool ThickTop { get; set; }

Property Value

Type	Description
bool	The thick top returned by the operation.

Remarks

A Row represents a horizontal collection of cells in a worksheet. Rows can have custom height, visibility settings, and formatting applied.

Rows are accessed through the Rows collection.

Methods

Autofit()

Set the height of the row so that it fits its content

Declaration

public void Autofit()

Remarks

A Row represents a horizontal collection of cells in a worksheet. Rows can have custom height, visibility settings, and formatting applied.

Rows are accessed through the Rows collection.

Autofit(int, int)

Set the height of the row so that it fits its content, considering only cells in the specified column range.

Declaration

public void Autofit(int fromColumn, int toColumn)

Parameters

Type	Name	Description
int	fromColumn	Zero-based index of the first column to consider.
int	toColumn	Zero-based index of the last column to consider.

Remarks

A Row represents a horizontal collection of cells in a worksheet. Rows can have custom height, visibility settings, and formatting applied.

Rows are accessed through the Rows collection.

GetNonEmptyCells()

Gets the non empty cells from the cell storage ordered by column or row index.

Declaration

public virtual IEnumerable<Cell> GetNonEmptyCells()

Returns

Type	Description
IEnumerable<Cell>

Remarks

In case of merged cells only the first cell is returned.

SetDefaultHeight()

Updates the default height held by the Row.

Declaration

public void SetDefaultHeight()

Remarks

A Row represents a horizontal collection of cells in a worksheet. Rows can have custom height, visibility settings, and formatting applied.

Rows are accessed through the Rows collection.

ToString()

Converts the supplied data for use with the Row.

Declaration

public override string ToString()

Returns

Type	Description
string	The to string returned by the operation.

Overrides

object.ToString()

Remarks

A Row represents a horizontal collection of cells in a worksheet. Rows can have custom height, visibility settings, and formatting applied.

Rows are accessed through the Rows collection.

Operators

operator +(Row, int)

Exposes the operator associated with Row.

Declaration

public static Row operator +(Row This, int offset)

Parameters

Type	Name	Description
Row	This	The this used by the operation.
int	offset	The offset used by the operation.

Returns

Type	Description
Row	The operator returned by the operation.

Remarks

A Row represents a horizontal collection of cells in a worksheet. Rows can have custom height, visibility settings, and formatting applied.

Rows are accessed through the Rows collection.

operator >=(Row, Row)

Exposes the operator associated with Row.

Declaration

public static bool operator >=(Row dim1, Row dim2)

Parameters

Type	Name	Description
Row	dim1	The dim1 used by the operation.
Row	dim2	The dim2 used by the operation.

Returns

Type	Description
bool	The operator returned by the operation.

Remarks

A Row represents a horizontal collection of cells in a worksheet. Rows can have custom height, visibility settings, and formatting applied.

Rows are accessed through the Rows collection.

operator <=(Row, Row)

Exposes the operator associated with Row.

Declaration

public static bool operator <=(Row dim1, Row dim2)

Parameters

Type	Name	Description
Row	dim1	The dim1 used by the operation.
Row	dim2	The dim2 used by the operation.

Returns

Type	Description
bool	The operator returned by the operation.

Remarks

A Row represents a horizontal collection of cells in a worksheet. Rows can have custom height, visibility settings, and formatting applied.

Rows are accessed through the Rows collection.