Open In App
Related Articles

PHP | Spreadsheet | Setting a date and/or time value in a cell

Improve Article
Save Article
Like Article

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.


// PHP program to set a date time value in excel sheet
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
// Creates New Spreadsheet
$spreadsheet = new Spreadsheet(); 
// Retrieve the current active worksheet
$sheet = $spreadsheet->getActiveSheet(); 
// Set the number format mask so that the excel timestamp 
// will be displayed as a human-readable date/time
// Get current date and timestamp
// Convert to an Excel date/time
$dateTime = time(); 
$excelDateValue = \PhpOffice\PhpSpreadsheet\Shared\Date::PHPToExcel(
                  $dateTime ); 
// Set cell A1 with the Formatted date/time value
// Write an .xlsx file 
$writer = new Xlsx($spreadsheet);
// Save .xlsx file to the current directory



Whether you're preparing for your first job interview or aiming to upskill in this ever-evolving tech landscape, GeeksforGeeks Courses are your key to success. We provide top-quality content at affordable prices, all geared towards accelerating your growth in a time-bound manner. Join the millions we've already empowered, and we're here to do the same for you. Don't miss out - check it out now!

Last Updated : 19 Nov, 2018
Like Article
Save Article
Similar Reads
Complete Tutorials