C# Класс ExcelFormulaParser.Engine.ExcelUtilities.AddressTranslator

Handles translations from Spreadsheet addresses to 0-based numeric index.
Показать файл Открыть проект Примеры использования класса

Открытые методы

Метод Описание
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.

Приватные методы

Метод Описание
GetAlphaPart ( string address ) : string
GetIntPart ( string address ) : int?
GetNumericAlphaValue ( char c ) : int
GetRowIndexByBehaviour ( RangeCalculationBehaviour behaviour ) : int

Описание методов

AddressTranslator() публичный Метод

public AddressTranslator ( ExcelDataProvider excelDataProvider ) : System
excelDataProvider ExcelDataProvider
Результат System

ToColAndRow() публичный Метод

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
Результат void

ToColAndRow() публичный Метод

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
Результат void