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.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

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