Class SqRefUtility

Namespace

OfficeOpenXml.Utils

Assembly

EPPlus.dll

Class for handling translation between ExcelAddresses and sqref addresses.

public static class SqRefUtility

Inheritance

object

SqRefUtility

Inherited Members

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

Methods

FromSqRefAddress(string)

Transforms an sqRef address into a excel address

public static string FromSqRefAddress(string address)

Parameters

address string

The address to transform

Returns

string

A valid excel address

ToSqRefAddress(string)

Transforms an address to a valid sqRef address.

public static string ToSqRefAddress(string address)

Parameters

address string

The address to transform

Returns

string

A valid SqRef address