Class SqRefUtility
Class for handling translation between ExcelAddresses and sqref addresses.
Inherited Members
Namespace: OfficeOpenXml.Utils
Assembly: EPPlus.dll
Syntax
public static class SqRefUtilityMethods
FromSqRefAddress(string)
Transforms an sqRef address into a excel address
Declaration
public static string FromSqRefAddress(string address)Parameters
| Type | Name | Description |
|---|---|---|
| string | address | The address to transform |
Returns
| Type | Description |
|---|---|
| string | A valid excel address |
ToSqRefAddress(string)
Transforms an address to a valid sqRef address.
Declaration
public static string ToSqRefAddress(string address)Parameters
| Type | Name | Description |
|---|---|---|
| string | address | The address to transform |
Returns
| Type | Description |
|---|---|
| string | A valid SqRef address |