Class SqRefUtility

Class for handling translation between ExcelAddresses and sqref addresses.

Inheritance

Object

SqRefUtility

Inherited Members

Object.Equals(Object)

Object.Equals(Object, Object)

Object.GetHashCode()

Object.GetType()

Object.MemberwiseClone()

Object.ReferenceEquals(Object, Object)

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