You are here

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