manojchowrasiya / php-excel-reader

Automatically exported from code.google.com/p/php-excel-reader
0 stars 0 forks source link

Bad count of sheets with ods file #190

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago
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