Skip to content

Bad count of sheets with ods file #190

Open
@GoogleCodeExporter

Description

@GoogleCodeExporter
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 [email protected] on 17 Jun 2014 at 7:16

Metadata

Metadata

Assignees

No one assigned

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions