how to get date from excel using PHPExcel library

php date phpexcel
user2934950 picture user2934950 · Oct 30, 2013 · Viewed 48.8k times · Source

I am trying to get Date from excel using PHPExcel. But I am not getting date, I am getting string value which is not seconds from 1970 .

Code I have tried is 

$InvDate=trim($excel->getActiveSheet()->getCell('B' . $i)->getValue());

Answer

Sergey picture Sergey · Oct 30, 2013

Try use 

$cell = $excel->getActiveSheet()->getCell('B' . $i);
$InvDate= $cell->getValue();
if(PHPExcel_Shared_Date::isDateTime($cell)) {
     $InvDate = date($format, PHPExcel_Shared_Date::ExcelToPHP($InvDate)); 
}

P.S.

@DiegoDD: Should mention that $format is the desired format for the date. e.g.:

 $InvDate = date($format = "Y-m-d", PHPExcel_Shared_Date::ExcelToPHP($InvDate));

P.P.S. 2019 Look at answer @gabriel-lupu, with new version of PhpOffice https://stackoverflow.com/a/45070205/426533

Related questions

Convert a date format in PHP

I am trying to convert a date from yyyy-mm-dd to dd-mm-yyyy (but not in SQL); however I don't know how the date function requires a timestamp, and I can't get a timestamp from this string. How is this possible?

Read More
How do I use PHP to get the current year?

I want to put a copyright notice in the footer of a web site, but I think it's incredibly tacky for the year to be outdated. How would I make the year update automatically with PHP 4 or PHP 5?

Read More
Converting string to Date and DateTime

If I have a PHP string in the format of mm-dd-YYYY (for example, 10-16-2003), how do I properly convert that to a Date and then a DateTime in the format of YYYY-mm-dd? The only reason I ask for both …

Read More