You are here

public function PHPExcel_Worksheet::setCellValueByColumnAndRow in Loft Data Grids 6.2

Same name and namespace in other branches
  1. 7.2 vendor/phpoffice/phpexcel/Classes/PHPExcel/Worksheet.php \PHPExcel_Worksheet::setCellValueByColumnAndRow()

Set a cell value by using numeric cell coordinates

Parameters

string $pColumn Numeric column coordinate of the cell (A = 0):

string $pRow Numeric row coordinate of the cell:

mixed $pValue Value of the cell:

bool $returnCell Return the worksheet (false, default) or the cell (true):

Return value

PHPExcel_Worksheet|PHPExcel_Cell Depending on the last parameter being specified

File

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

Class

PHPExcel_Worksheet
PHPExcel_Worksheet

Code

public function setCellValueByColumnAndRow($pColumn = 0, $pRow = 1, $pValue = null, $returnCell = false) {
  $cell = $this
    ->getCellByColumnAndRow($pColumn, $pRow)
    ->setValue($pValue);
  return $returnCell ? $cell : $this;
}