Class R1C1Translator¶

Namespace: OfficeOpenXml.Core
Assembly: EPPlus.dll

Translate addresses between the R1C1 and A1 notation

public static class R1C1Translator

Inheritance¶

object ← R1C1Translator

Inherited Members¶

object.Equals(object?, object?)
object.Equals(object?)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
object.ReferenceEquals(object?, object?)
object.ToString()

Methods¶

FromR1C1(string, int, int, bool)¶

Translate an address from R1C1 to A1

public static string FromR1C1(string r1C1Address, int row, int col, bool rollIfOverflow = false)

Parameters¶

r1C1Address string

The address

row int

The row of the cell to calculate from

col int

The column of the cell to calculate from

rollIfOverflow bool

If row or col exceeds the maximum value the row/col will start over from 1

Returns¶

string

The address in A1 notation

FromR1C1Formula(string, int, int, bool)¶

Translate addresses in a formula from R1C1 to A1

public static string FromR1C1Formula(string formula, int row, int col, bool rollIfOverflow = false)

Parameters¶

formula string

The formula

row int

The row of the cell to calculate from

col int

The column of the cell to calculate from

rollIfOverflow bool

If row or col exceeds the maximum value the row/col will start over from 1

Returns¶

string

The formula in A1 notation

ToR1C1(ExcelAddressBase, int, int)¶

Translate an address from A1 to R1C1

public static string ToR1C1(ExcelAddressBase address, int row, int col)

Parameters¶

address ExcelAddressBase

The address

row int

The row of the cell to calculate from

col int

The column of the cell to calculate from

Returns¶

string

The address in R1C1 notation

ToR1C1Formula(string, int, int)¶

Translate addresses in a formula from A1 to R1C1

public static string ToR1C1Formula(string formula, int row, int col)

Parameters¶

formula string

The formula

row int

The row of the cell to calculate from

col int

The column of the cell to calculate from

Returns¶

string

The formula in R1C1 notation