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

Set a cell value

Parameters

string $pCoordinate 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 1123

Class

PHPExcel_Worksheet

PHPExcel_Worksheet

Code

public function setCellValueExplicit($pCoordinate = 'A1', $pValue = null, $pDataType = PHPExcel_Cell_DataType::TYPE_STRING, $returnCell = false) {

  // Set value
  $cell = $this
    ->getCell(strtoupper($pCoordinate))
    ->setValueExplicit($pValue, $pDataType);
  return $returnCell ? $cell : $this;
}