Class AddressTranslator

Handles translations from Spreadsheet addresses to 0-based numeric index.

Inheritance

System.Object

AddressTranslator

Inherited Members

System.Object.Equals(System.Object)

System.Object.Equals(System.Object, System.Object)

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

System.Object.ReferenceEquals(System.Object, System.Object)

System.Object.ToString()

Namespace: OfficeOpenXml.FormulaParsing.ExcelUtilities

Assembly: EPPlus.dll

Syntax

public class AddressTranslator

Constructors

AddressTranslator(ExcelDataProvider)

Declaration

public AddressTranslator(ExcelDataProvider excelDataProvider)

Parameters

Type	Name	Description
ExcelDataProvider	excelDataProvider

Methods

ToColAndRow(String, out Int32, out Int32)

Translates an address in format "A1" to col- and rowindex.

If the supplied address is a range, the address of the first part will be calculated.

Declaration

public virtual void ToColAndRow(string address, out int col, out int row)

Parameters

Type	Name	Description
System.String	address
System.Int32	col
System.Int32	row

ToColAndRow(String, out Int32, out Int32, AddressTranslator.RangeCalculationBehaviour)

Translates an address in format "A1" to col- and rowindex.

Declaration

public virtual void ToColAndRow(string address, out int col, out int row, AddressTranslator.RangeCalculationBehaviour behaviour)

Parameters

Type	Name	Description
System.String	address
System.Int32	col
System.Int32	row
AddressTranslator.RangeCalculationBehaviour	behaviour