phpexcel not reading sheet correctly

887 Views Asked by At

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!

0

There are 0 best solutions below