public function PHPExcel_Worksheet::getCellByColumnAndRow in Loft Data Grids 7.2

Same name and namespace in other branches

1. 6.2 vendor/phpoffice/phpexcel/Classes/PHPExcel/Worksheet.php \PHPExcel_Worksheet::getCellByColumnAndRow()

Get cell at a specific coordinate by using numeric cell coordinates

Parameters

string $pColumn Numeric column coordinate of the cell:

string $pRow Numeric row coordinate of the cell:

Return value

PHPExcel_Cell Cell that was found

File

vendor/phpoffice/phpexcel/Classes/PHPExcel/Worksheet.php, line 1197

Class

PHPExcel_Worksheet

PHPExcel_Worksheet

Code

public function getCellByColumnAndRow($pColumn = 0, $pRow = 1) {
  $columnLetter = PHPExcel_Cell::stringFromColumnIndex($pColumn);
  $coordinate = $columnLetter . $pRow;
  if ($this->_cellCollection
    ->isDataSet($coordinate)) {
    return $this->_cellCollection
      ->getCacheData($coordinate);
  }
  return $this
    ->_createNewCell($coordinate);
}