C# Class ExcelFormulaParser.Engine.ExcelUtilities.AddressTranslator

Handles translations from Spreadsheet addresses to 0-based numeric index.
Show file Open project: swmal/ExcelFormulaParser Class Usage Examples

Public Methods

Method Description
AddressTranslator ( ExcelDataProvider excelDataProvider ) : System
ToColAndRow ( string address, int &col, int &row ) : void

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.
ToColAndRow ( string address, int &col, int &row, RangeCalculationBehaviour behaviour ) : void

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

Private Methods

Method Description
GetAlphaPart ( string address ) : string
GetIntPart ( string address ) : int?
GetNumericAlphaValue ( char c ) : int
GetRowIndexByBehaviour ( RangeCalculationBehaviour behaviour ) : int

Method Details

AddressTranslator() public method

public AddressTranslator ( ExcelDataProvider excelDataProvider ) : System
excelDataProvider ExcelDataProvider
return System

ToColAndRow() public method

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.
public ToColAndRow ( string address, int &col, int &row ) : void
address string
col int
row int
return void

ToColAndRow() public method

Translates an address in format "A1" to col- and rowindex.
public ToColAndRow ( string address, int &col, int &row, RangeCalculationBehaviour behaviour ) : void
address string
col int
row int
behaviour RangeCalculationBehaviour
return void