PHPExcel Reader Date Format Issue - rangeToArray
I am facing a Date format issue when reading excel using PHPExcel. Even I
used $objReader->setReadDataOnly(false); getting format of the cell but
not working for me. This how I am reading the data from Excel.
$get_excel_data =
$objPHPExcel->getActiveSheet()->rangeToArray("A1:".$highestColumn.$highestRow);
When I am trying to print date, it shows like 03/06/13, and I have tried
to convert in mysl date format using
date('Y-m-d',PHPExcel_Shared_Date::ExcelToPHP($val[1]))
But it is not working, Can anyone guide me to the issue ? The main problem
is I am not getting the date as number format ( Excel ), Instead of it
showing date as 03/06/13,
No comments:
Post a Comment