I am facing a problem with the PHPExcel class while i am using that class to read a excel file in my php code.
// Reading the excel data
$objReader = new PHPExcel_Reader_Excel2007();
$objReader->setReadDataOnly(true);
$objPHPExcel = $objReader->load('test.xlsx');
$objPHPExcel->setActiveSheetIndex(0);
$dataArray = $objPHPExcel->getActiveSheet()->toArray();
I am using this code, Now problem is that when I create a excel file and insert a cell value like a date say 01/09/2012
and reads the full excelsheet using the toarray() function of PHPExcel class, then it do not returns the date value. it's returning a numeric value.
What I found that when we create the Excel file using the MS OFfice application and insert a date into any cell the excel converts the cell to a date format. So now I want to read a date format cell using the PHPExcel class.