ExcelFormulaParser.Engine.ExcelUtilities.AddressTranslator.ToColAndRow C# (CSharp) Method

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
        public virtual void ToColAndRow(string address, out int col, out int row)
        {
            ToColAndRow(address, out col, out row, RangeCalculationBehaviour.FirstPart);
        }

Same methods

AddressTranslator::ToColAndRow ( string address, int &col, int &row, RangeCalculationBehaviour behaviour ) : void

Usage Example

Example #1
0
        private void HandleSingleCellAddress(RangeAddress rangeAddress, ExcelAddressInfo addressInfo)
        {
            int col, row;

            _addressTranslator.ToColAndRow(addressInfo.StartCell, out col, out row);
            rangeAddress.FromCol = col;
            rangeAddress.ToCol   = col;
            rangeAddress.FromRow = row;
            rangeAddress.ToRow   = row;
        }