Class ExcelCellAddress
A single cell address
Inheritance
System.Object
ExcelCellAddress
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 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 |
|---|---|---|
| System.Int32 | row | The row. |
| System.Int32 | column | The column. |
| System.Boolean | isRowFixed | If the row is fixed, prefixed with $ |
| System.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 |
|---|---|---|
| System.String | address | The address |
Properties
Address
Celladdress
Declaration
public string Address { get; }Property Value
| Type | Description |
|---|---|
| System.String |
Column
Column
Declaration
public int Column { get; }Property Value
| Type | Description |
|---|---|
| System.Int32 |
IsColumnFixed
Returns true if the column is fixed
Declaration
public bool IsColumnFixed { get; }Property Value
| Type | Description |
|---|---|
| System.Boolean |
IsRef
If the address is an invalid reference (#REF!)
Declaration
public bool IsRef { get; }Property Value
| Type | Description |
|---|---|
| System.Boolean |
IsRowFixed
Returns true if the row is fixed
Declaration
public bool IsRowFixed { get; }Property Value
| Type | Description |
|---|---|
| System.Boolean |
Row
Row
Declaration
public int Row { get; }Property Value
| Type | Description |
|---|---|
| System.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 |
|---|---|---|
| System.Int32 | column | Index of the column (1-based) |
Returns
| Type | Description |
|---|---|
| System.String | The corresponding letter, like A for 1. |