I have an xlsx file with 4 sheets. Under Ubuntu, I saved the file in ods format.
I open this files with this code :
set_include_path ( get_include_path () . PATH_SEPARATOR .
'plugins/phpExcel-1.8.0/Classes/' );
include 'PHPExcel/IOFactory.php';
(...)
switch ($ext) {
case 'xls' :
$inputFileType = $objReader = new PHPExcel_Reader_Excel5 ();
break;
case 'ods' :
$objReader = new PHPExcel_Reader_OOCalc ();
break;
case 'xlsx' :
default :
$objReader = new PHPExcel_Reader_Excel2007 ();
}
$objReader->setLoadAllSheets ();
$excel = $objReader->load ( $_FILES ['upfile'] ['tmp_name'] );
$nbfeuille = $excel->getSheetCount ();
With ods file, getSheetCount() found 5 sheets, and the last is empty. In
libreoffice, I have only 4 sheets.
Tanks.
Original issue reported on code.google.com by quinton....@gmail.com on 17 Jun 2014 at 7:16
Original issue reported on code.google.com by
quinton....@gmail.com
on 17 Jun 2014 at 7:16