Class SqRefUtility

Class for handling translation between ExcelAddresses and sqref addresses.

Inheritance

System.Object

SqRefUtility

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.Utils

Assembly: EPPlus.dll

Syntax

public static class SqRefUtility

Methods

FromSqRefAddress(String)

Transforms an sqRef address into a excel address

Declaration

public static string FromSqRefAddress(string address)

Parameters

Type	Name	Description
System.String	address	The address to transform

Returns

Type	Description
System.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
System.String	address	The address to transform

Returns

Type	Description
System.String	A valid SqRef address