Class ExcelRow
Represents an individual row in the spreadsheet.
Inheritance
System.Object
ExcelRow
Inherited Members
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.ToString()
Namespace: OfficeOpenXml
Assembly: EPPlus.dll
Syntax
public class ExcelRow : IRangeIDProperties
Collapsed
If outline level is set this tells that the row is collapsed
Declaration
public bool Collapsed { get; set; }Property Value
| Type | Description |
|---|---|
| System.Boolean |
CustomHeight
Set to true if You don't want the row to Autosize
Declaration
public bool CustomHeight { get; set; }Property Value
| Type | Description |
|---|---|
| System.Boolean |
Height
Sets the height of the row
Declaration
public double Height { get; set; }Property Value
| Type | Description |
|---|---|
| System.Double |
Hidden
Allows the row to be hidden in the worksheet
Declaration
public bool Hidden { get; set; }Property Value
| Type | Description |
|---|---|
| System.Boolean |
Merged
Merge all cells in the row
Declaration
public bool Merged { get; set; }Property Value
| Type | Description |
|---|---|
| System.Boolean |
OutlineLevel
Outline level.
Declaration
public int OutlineLevel { get; set; }Property Value
| Type | Description |
|---|---|
| System.Int32 |
PageBreak
Adds a manual page break after the row.
Declaration
public bool PageBreak { get; set; }Property Value
| Type | Description |
|---|---|
| System.Boolean |
Phonetic
Show phonetic Information
Declaration
public bool Phonetic { get; set; }Property Value
| Type | Description |
|---|---|
| System.Boolean |
Row
Rownumber
Declaration
public int Row { get; set; }Property Value
| Type | Description |
|---|---|
| System.Int32 |
RowID
Internal RowID.
Declaration
[Obsolete]
public ulong RowID { get; }Property Value
| Type | Description |
|---|---|
| System.UInt64 |
Style
The Style applied to the whole row. Only effekt cells with no individual style set. Use ExcelRange object if you want to set specific styles.
Declaration
public ExcelStyle Style { get; }Property Value
| Type | Description |
|---|---|
| ExcelStyle |
StyleID
Sets the style for the entire row using the style ID.
Declaration
public int StyleID { get; set; }Property Value
| Type | Description |
|---|---|
| System.Int32 |
StyleName
Sets the style for the entire column using a style name.
Declaration
public string StyleName { get; set; }Property Value
| Type | Description |
|---|---|
| System.String |