public function PHPExcel_Worksheet::setCellValueExplicitByColumnAndRow 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::setCellValueExplicitByColumnAndRow()

Set a cell value by using numeric cell coordinates

Parameters

string $pColumn Numeric column coordinate of the cell:

string $pRow Numeric row coordinate of the cell:

mixed $pValue Value of the cell:

string $pDataType Explicit data type:

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 1140

Class

PHPExcel_Worksheet

PHPExcel_Worksheet

Code

public function setCellValueExplicitByColumnAndRow($pColumn = 0, $pRow = 1, $pValue = null, $pDataType = PHPExcel_Cell_DataType::TYPE_STRING, $returnCell = false) {
  $cell = $this
    ->getCellByColumnAndRow($pColumn, $pRow)
    ->setValueExplicit($pValue, $pDataType);
  return $returnCell ? $cell : $this;
}