public static function PHPExcel_Cell::getRangeBoundaries 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::getRangeBoundaries()

* Calculate range boundaries * *

Parameters

string $pRange Cell range (e.g. A1:A1): * @return array Range coordinates array(Start Cell, End Cell) * where Start Cell and End Cell are arrays (Column ID, Row Number)

2 calls to PHPExcel_Cell::getRangeBoundaries()

PHPExcel_Reader_Excel5::_includeCellRangeFiltered in vendor/phpoffice/phpexcel/Classes/PHPExcel/Reader/Excel5.php

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

Accepts a range, returning it as a range that falls within the current highest row and column of the worksheet

File

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

Class

PHPExcel_Cell

PHPExcel_Cell

Code

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

  // Ensure $pRange is a valid range
  if (empty($pRange)) {
    $pRange = self::DEFAULT_RANGE;
  }

  // Uppercase coordinate
  $pRange = strtoupper($pRange);

  // Extract range
  if (strpos($pRange, ':') === FALSE) {
    $rangeA = $rangeB = $pRange;
  }
  else {
    list($rangeA, $rangeB) = explode(':', $pRange);
  }
  return array(
    self::coordinateFromString($rangeA),
    self::coordinateFromString($rangeB),
  );
}