$csvFileName = str_replace('.xlsx', '.csv', $uploadfile); $objWriter->save($csvFileName); if (($handle = fopen($csvFileName, "r")) !== false) { while (($data = fgetcsv($handle, 1000, ",")) !== false) { $num = count($data); for ($c = 0; $c < $num; $c++) { echo $data[$c] . "<br />\n"; } } fclose($handle); } $objReader = new PHPExcel_Reader_Excel5(); $objReader->setReadDataOnly(true); $objPHPExcel = $objReader->load("uploadfile"); $colunas = $objPHPExcel->setActiveSheetIndex(0)->getHighestColumn(); $totalColunas = PHPExcel_Cell::columnByIndexFromString($colunas); $totalLinhas = $objPHPExcel->setActiveSheetIndex(0)->getHighetRows(); for ($linha = 1; $linha <= $totalLinhas; $linha++) { for ($coluna = 0; $coluna <= $totalColunas; $coluna++) { if ($linha == 1) { echo utf8_decode($objPHPExcel->getActiveSheet()->getCellColumnAndRow($coluna, $linha)->getValue()); } else { echo utf8_decode($objPHPExcel->getActiveSheet()->getCellColumnAndRow($coluna, $linha)->getValue()); } } } } ?> </body> </html>