C# Class ExcelFormulaParser.Engine.ExcelUtilities.AddressTranslator

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

Méthodes publiques

Méthode 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

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

Method Details

AddressTranslator() public méthode

public AddressTranslator ( ExcelDataProvider excelDataProvider ) : System
excelDataProvider ExcelDataProvider
Résultat System

ToColAndRow() public méthode

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
Résultat void

ToColAndRow() public méthode

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
Résultat void