PHP | Spreadsheet | Setting a date and/or time value in a cell
Last Updated :
07 Mar, 2024
In PHP Spreadsheet, the date or time values are stored in an excel sheet in the form of timestamp which is a floating point value. So in order to store date/time in a human-readable format, need to calculate the correct excel timestamp and finally set a number format mask.
Example:
<?php
require_once ( 'vendor/autoload.php' );
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
$spreadsheet = new Spreadsheet();
$sheet = $spreadsheet ->getActiveSheet();
$spreadsheet ->getActiveSheet()->getStyle( 'A1' )
->getNumberFormat()
->setFormatCode(
\PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_DATE_DATETIME
);
$dateTime = time();
$excelDateValue = \PhpOffice\PhpSpreadsheet\Shared\ Date ::PHPToExcel(
$dateTime );
$sheet ->setCellValue( 'A1' , $excelDateValue );
$writer = new Xlsx( $spreadsheet );
$writer ->save( 'gfgdate.xlsx' );
?>
|
Output:
Share your thoughts in the comments
Please Login to comment...