C# (CSharp) OfficeOpenXml.FormulaParsing.ExcelUtilities ExcelAddressInfo Examples

Example #1

File: RangeAddressFactory.cs Project: vsoares/EPPlusEncryptedPackage

        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;
        }

Example #2

File: RangeAddressFactory.cs Project: vsoares/EPPlusEncryptedPackage

        private void HandleMultipleCellAddress(RangeAddress rangeAddress, ExcelAddressInfo addressInfo)
        {
            int fromCol, fromRow;

            _addressTranslator.ToColAndRow(addressInfo.StartCell, out fromCol, out fromRow);
            int toCol, toRow;

            _addressTranslator.ToColAndRow(addressInfo.EndCell, out toCol, out toRow, AddressTranslator.RangeCalculationBehaviour.LastPart);
            rangeAddress.FromCol = fromCol;
            rangeAddress.ToCol   = toCol;
            rangeAddress.FromRow = fromRow;
            rangeAddress.ToRow   = toRow;
        }

Example #3

File: RangeAddressFactory.cs Project: GitOffice/DataPie

 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;
 }

Example #4

File: RangeAddressFactory.cs Project: GitOffice/DataPie

 private void HandleMultipleCellAddress(RangeAddress rangeAddress, ExcelAddressInfo addressInfo)
 {
     int fromCol, fromRow;
     _addressTranslator.ToColAndRow(addressInfo.StartCell, out fromCol, out fromRow);
     int toCol, toRow;
     _addressTranslator.ToColAndRow(addressInfo.EndCell, out toCol, out toRow, AddressTranslator.RangeCalculationBehaviour.LastPart);
     rangeAddress.FromCol = fromCol;
     rangeAddress.ToCol = toCol;
     rangeAddress.FromRow = fromRow;
     rangeAddress.ToRow = toRow;
 }

Example #5

File: EpplusExcelDataProvider.cs Project: Eagle-Chan/KIS

 private void SetCurrentWorksheet(ExcelAddressInfo addressInfo)
 {
     if (addressInfo.WorksheetIsSpecified)
     {
         _currentWorksheet = _package.Workbook.Worksheets[addressInfo.Worksheet];
     }
     else if (_currentWorksheet == null)
     {
         _currentWorksheet = _package.Workbook.Worksheets.First();
     }
 }