C# 클래스 ExcelFormulaParser.Engine.ExcelUtilities.AddressTranslator

Handles translations from Spreadsheet addresses to 0-based numeric index.
파일 보기 프로젝트 열기: swmal/ExcelFormulaParser 1 사용 예제들

공개 메소드들

메소드 설명
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