Good day guys i have a problem on how to detect if the cell value is formated to date or not when i been upload a date value i use this code
$data = $objWorksheet->getCellByColumnAndRow($col, $row);
when a cell value is formated into date the value is $data = 27474
when is not $data = 12/2/1983
then i use this code to format their date
if(PHPExcel_Shared_Date::isDateTime($data)){
$cellValue = $objWorksheet->getCellByColumnAndRow($col, $row)->getValue();
$dateValue = PHPExcel_Shared_Date::ExcelToPHP($cellValue);
$dob = date('Y-m-d',$dateValue);
}
now, the problem is when $data
is in formated on date this code is OK but when $data
is not formated the value is $data = 2036-02-18
which is wrong value
can anyone help me how to resolve this problem Thanks in Advance