Class R1C1Translator
Translate addresses between the R1C1 and A1 notation
Inheritance
System.Object
R1C1Translator
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.Core
Assembly: EPPlus.dll
Syntax
public static class R1C1TranslatorMethods
FromR1C1(String, Int32, Int32)
Translate an address from R1C1 to A1
Declaration
public static string FromR1C1(string r1C1Address, int row, int col)Parameters
| Type | Name | Description |
|---|---|---|
| System.String | r1C1Address | The address |
| System.Int32 | row | The row of the cell to calculate from |
| System.Int32 | col | The column of the cell to calculate from |
Returns
| Type | Description |
|---|---|
| System.String | The address in A1 notation |
FromR1C1Formula(String, Int32, Int32)
Translate addresses in a formula from R1C1 to A1
Declaration
public static string FromR1C1Formula(string formula, int row, int col)Parameters
| Type | Name | Description |
|---|---|---|
| System.String | formula | The formula |
| System.Int32 | row | The row of the cell to calculate from |
| System.Int32 | col | The column of the cell to calculate from |
Returns
| Type | Description |
|---|---|
| System.String | The formula in A1 notation |
ToR1C1(ExcelAddressBase, Int32, Int32)
Translate an address from A1 to R1C1
Declaration
public static string ToR1C1(ExcelAddressBase address, int row, int col)Parameters
| Type | Name | Description |
|---|---|---|
| ExcelAddressBase | address | The address |
| System.Int32 | row | The row of the cell to calculate from |
| System.Int32 | col | The column of the cell to calculate from |
Returns
| Type | Description |
|---|---|
| System.String | The address in R1C1 notation |
ToR1C1Formula(String, Int32, Int32)
Translate addresses in a formula from A1 to R1C1
Declaration
public static string ToR1C1Formula(string formula, int row, int col)Parameters
| Type | Name | Description |
|---|---|---|
| System.String | formula | The formula |
| System.Int32 | row | The row of the cell to calculate from |
| System.Int32 | col | The column of the cell to calculate from |
Returns
| Type | Description |
|---|---|
| System.String | The formula in R1C1 notation |