I am using phpexcel 1.8 to read a .xlsx file with 92 rows. But I am getting only one row as the result. Then I opened the file & made some edits using libre office & then I tried to save the file & an option came up "Use Microsoft Excel 2007/2010/2013 XML Format" & I clicked on it & saved the file.
Then onwards I am getting correct results from reading the file using phpexcel. What could be wrong ? Any help would be appreciated.
Code I used is:
$inputFileName = 'test.xlsx';
try {
$objPHPExcel = PHPExcel_IOFactory::load($inputFileName);
} catch (Exception $e) {
die('Error loading file "' . pathinfo($inputFileName, PATHINFO_BASENAME) . '": ' . $e->getMessage());
}
$highRow = $objPHPExcel->setActiveSheetIndex(0)->getHighestRow();
$highColumn = $objPHPExcel->setActiveSheetIndex(0)->getHighestColumn();
Thanks in advance!