public static function PHPExcel_Cell::splitRange in Loft Data Grids 7.2

Same name and namespace in other branches

1. 6.2 vendor/phpoffice/phpexcel/Classes/PHPExcel/Cell.php \PHPExcel_Cell::splitRange()

* Split range into coordinate strings * *

Parameters

string $pRange e.g. 'B4:D9' or 'B4:D9,H2:O11' or 'B4': * @return array Array containg one or more arrays containing one or two coordinate strings * e.g. array('B4','D9') or array(array('B4','D9'),array('H2','O11')) * or array('B4')

14 calls to PHPExcel_Cell::splitRange()

PHPExcel_Calculation::extractNamedRange in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation.php

* Extract range values * *

PHPExcel_Cell::extractAllCellReferencesInRange in vendor/phpoffice/phpexcel/Classes/PHPExcel/Cell.php

* Extract all cell references in range * *

PHPExcel_Cell::isMergeRangeValueCell in vendor/phpoffice/phpexcel/Classes/PHPExcel/Cell.php

* Is this cell the master (top left cell) in a merge range (that holds the actual data value) * *

PHPExcel_ReferenceHelper::_updateCellRange in vendor/phpoffice/phpexcel/Classes/PHPExcel/ReferenceHelper.php

* Update cell range * *

PHPExcel_Worksheet::setSelectedCells in vendor/phpoffice/phpexcel/Classes/PHPExcel/Worksheet.php

Select a range of cells.

... See full list

File

vendor/phpoffice/phpexcel/Classes/PHPExcel/Cell.php, line 660

Class

PHPExcel_Cell

PHPExcel_Cell

Code

public static function splitRange($pRange = 'A1:A1') {

  // Ensure $pRange is a valid range
  if (empty($pRange)) {
    $pRange = self::DEFAULT_RANGE;
  }
  $exploded = explode(',', $pRange);
  $counter = count($exploded);
  for ($i = 0; $i < $counter; ++$i) {
    $exploded[$i] = explode(':', $exploded[$i]);
  }
  return $exploded;
}