Class ExcelCellAddress
A single cell address
Inheritance
Object
ExcelCellAddress
Inherited Members
Object.Equals(Object)
Object.Equals(Object, Object)
Object.GetHashCode()
Object.GetType()
Object.MemberwiseClone()
Object.ReferenceEquals(Object, Object)
Object.ToString()
Namespace: OfficeOpenXml
Assembly: EPPlus.dll
Syntax
public class ExcelCellAddressConstructors
ExcelCellAddress()
Initializes a new instance of the ExcelCellAddress class.
Declaration
public ExcelCellAddress()ExcelCellAddress(Int32, Int32, Boolean, Boolean)
Initializes a new instance of the ExcelCellAddress class.
Declaration
public ExcelCellAddress(int row, int column, bool isRowFixed = false, bool isColumnFixed = false)Parameters
| Type | Name | Description |
|---|---|---|
| Int32 | row | The row. |
| Int32 | column | The column. |
| Boolean | isRowFixed | If the row is fixed, prefixed with $ |
| Boolean | isColumnFixed | If the column is fixed, prefixed with $ |
ExcelCellAddress(String)
Initializes a new instance of the ExcelCellAddress class.
Declaration
public ExcelCellAddress(string address)Parameters
| Type | Name | Description |
|---|---|---|
| String | address | The address |
Properties
Address
Celladdress
Declaration
public string Address { get; }Property Value
| Type | Description |
|---|---|
| String |
Column
Column
Declaration
public int Column { get; }Property Value
| Type | Description |
|---|---|
| Int32 |
IsColumnFixed
Returns true if the column is fixed
Declaration
public bool IsColumnFixed { get; }Property Value
| Type | Description |
|---|---|
| Boolean |
IsRef
If the address is an invalid reference (#REF!)
Declaration
public bool IsRef { get; }Property Value
| Type | Description |
|---|---|
| Boolean |
IsRowFixed
Returns true if the row is fixed
Declaration
public bool IsRowFixed { get; }Property Value
| Type | Description |
|---|---|
| Boolean |
Row
Row
Declaration
public int Row { get; }Property Value
| Type | Description |
|---|---|
| Int32 |
Methods
GetColumnLetter(Int32)
Returns the letter corresponding to the supplied 1-based column index.
Declaration
public static string GetColumnLetter(int column)Parameters
| Type | Name | Description |
|---|---|---|
| Int32 | column | Index of the column (1-based) |
Returns
| Type | Description |
|---|---|
| String | The corresponding letter, like A for 1. |