PHP | Spreadsheet | Setting a cell value by coordinate
Last Updated :
07 Mar, 2024
The setCellValue() function is an inbuilt function in PHPSpreadsheet which is used to set the value of a cell in a spreadsheet.
Syntax:
setCellValue( $coordinate, $value )
Parameters: This function accepts two parameters as mentioned above and described below:
- $coordinate: This parameter is used to store the value of the coordinate of the excel sheet.
- $value: This parameter is used to store the value of data which is to be set in an excel sheet.
Return Value: This function returns Object of class PhpOffice\PhpSpreadsheet\Worksheet\Worksheet.
Example 1:
PHP
<?php
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
$spreadsheet = new Spreadsheet();
$sheet = $spreadsheet ->getActiveSheet();
$sheet ->setCellValue( 'A1' , 'GeeksForGeeks!' );
$sheet ->setCellValue( 'A2' , TRUE);
$sheet ->setCellValue( 'B1' , 123.456);
$writer = new Xlsx( $spreadsheet );
$writer ->save( 'gfg1.xlsx' );
?>
|
Output:
Alternatively, It can be achieved by retrieving the cell object firstly and then set the value. For this purpose, Cell object can be retrieved with the help of getCell() function, and then the value can be set with the help of setValue() function.
Syntax:
$spreadsheet->getActiveSheet()->getCell($coordinate)->setValue($value);
Example 2:
PHP
<?php
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
$spreadsheet = new Spreadsheet();
$sheet = $spreadsheet ->getActiveSheet();
$sheet ->getCell( 'A1' )->setValue( 'GeeksForGeeks!' );
$sheet ->getCell( 'A2' )->setValue(TRUE);
$sheet ->getCell( 'B1' )->setValue(123.456);
$writer = new Xlsx( $spreadsheet );
$writer ->save( 'gfg2.xlsx' );
?>
|
Output:
Share your thoughts in the comments
Please Login to comment...