Class ExcelRow¶

Namespace: OfficeOpenXml
Assembly: EPPlus.dll

Represents an individual row in the spreadsheet.

public class ExcelRow

Inheritance¶

object ← ExcelRow

Inherited Members¶

object.Equals(object?, object?)
object.Equals(object?)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
object.ReferenceEquals(object?, object?)
object.ToString()

Properties¶

Collapsed¶

If outline level is set this tells that the row is collapsed. Setting this property will not hide the children. Use the CollapseChildren(bool) or SetVisibleOutlineLevel(int, bool) methods to collapse and hide columns/rows via the Rows collection.

public bool Collapsed { get; set; }

Property Value¶

bool

CustomHeight¶

Set to true if You don't want the row to Autosize

public bool CustomHeight { get; set; }

Property Value¶

bool

Height¶

Sets the height of the row

public double Height { get; set; }

Property Value¶

double

Hidden¶

Allows the row to be hidden in the worksheet

public bool Hidden { get; set; }

Property Value¶

bool

Merged¶

Merge all cells in the row

public bool Merged { get; set; }

Property Value¶

bool

OutlineLevel¶

Outline level.

public int OutlineLevel { get; set; }

Property Value¶

int

PageBreak¶

Adds a manual page break after the row.

public bool PageBreak { get; set; }

Property Value¶

bool

Phonetic¶

Show phonetic Information

public bool Phonetic { get; set; }

Property Value¶

bool

Row¶

Rownumber

public int Row { get; set; }

Property Value¶

int

RowID¶

Internal RowID.

[Obsolete]
public ulong RowID { get; }

Property Value¶

ulong

Style¶

The Style applied to the whole row. Only effekt cells with no individual style set. Use the Cells Style property if you want to set specific styles.

public ExcelStyle Style { get; }

Property Value¶

ExcelStyle

StyleID¶

Sets the style for the entire row using the style ID.

public int StyleID { get; set; }

Property Value¶

int

StyleName¶

Sets the style for the entire column using a style name.

public string StyleName { get; set; }

Property Value¶

string