Reading xls Date Values with php excel reader

Question

I am using PHPExcel to read date cells in excel file that have values like 'Mar-13' but it is returning integer values like '41791'. Please, what do I need to do make sure that the date reads in correctly?

Gerard · Accepted Answer · 2014-07-17 07:07:58Z

6

Excel stores dates as serialized timestamps (number of days since 1/1/1900), which you can convert to Unix timestamp and format it with standard php date functions

$unix_timestamp = ($cell_value - 25569) * 86400;
$phpdate = date("m-d-Y", $unix_timestamp);

answered Jul 17, 2014 at 7:07

Gerard

1901 gold badge2 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Mansi Raja Over a year ago

How can I check the value is having date or not using PHP spreadsheet ?

Collectives™ on Stack Overflow

Reading xls Date Values with php excel reader

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related