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.Equals(object?, object?)
object.Equals(object?)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
object.ReferenceEquals(object?, object?)
object.ToString()

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