if (file_exists($inputFileName)) {
$inputFileType = PHPExcel_IOFactory::identify($inputFileName);
$objReader = PHPExcel_IOFactory::createReader($inputFileType);
$objReader->setReadDataOnly(true);
$objPHPExcel = $objReader->load($inputFileName);
$objWorksheet = $objPHPExcel->setActiveSheetIndex(0);
$highestRow = $objWorksheet->getHighestRow();
$highestColumn = $objWorksheet->getHighestColumn();
$headingsArray = $objWorksheet->rangeToArray('A3:'.$highestColumn.'3',null, true, true, true);
$headingsArray = $headingsArray[3];
$r = -3;
$namedDataArray = array();
for ($row = 5; $row <= $highestRow; ++$row) {
$dataRow = $objWorksheet->rangeToArray('A'.$row.':'.$highestColumn.$row,null, true, true, true);
if (((isset($dataRow[$row]['B'])) && ($dataRow[$row]['B'] > '')) &&((isset($dataRow[$row]['C'])) && ($dataRow[$row]['C'] > '')) &&((isset($dataRow[$row]['D'])) && ($dataRow[$row]['D'] > '')) &&((isset($dataRow[$row]['E'])) && ($dataRow[$row]['E'] > ''))) {
++$r;
foreach($headingsArray as $columnKey => $columnHeading) {
$namedDataArray[$r][$columnHeading] = $dataRow[$row][$columnKey];
}
}
}
}