php - Read only specific sheet -

i trying read 1 sheet xls document , have this:

 $objphpexcel = $objreader->load('daily/' . $fisierinbound);  $objworksheet = $objphpexcel->setactivesheetindex(0);  foreach ($objphpexcel->getworksheetiterator() $worksheet) {              $worksheettitle     = $worksheet->gettitle();             $highestrow         = $worksheet->gethighestrow(); // e.g. 10             $highestcolumn      = $worksheet->gethighestcolumn(); // e.g 'f'             $highestcolumnindex = phpexcel_cell::columnindexfromstring($highestcolumn);             $datacalls = $worksheet->getcellbycolumnandrow(2, 2)->getvalue();             $datasubstr = substr($datacalls, 53);           }  

the problem reads sheets of file.

any ideas?

as described in phpexcel user documentation - reading spreadsheet files document in /documentation folder (section 5.2. entitled"reading named worksheets file"):

if know name of sheet want read.

$inputfiletype = 'excel5';  $inputfilename = './sampledata/example1.xls';  $sheetname = 'data sheet #2';   /**  create new reader of type defined in $inputfiletype  **/  $objreader = phpexcel_iofactory::createreader($inputfiletype);  /**  advise reader of worksheets want load  **/  $objreader->setloadsheetsonly($sheetname);  /**  load $inputfilename phpexcel object  **/  $objphpexcel = $objreader->load($inputfilename);  

if don't know name of worksheet in advance, can list of worksheets before loading file

$inputfiletype = 'excel5';  $inputfilename = './sampledata/example1.xls';   /**  create new reader of type defined in $inputfiletype  **/  $objreader = phpexcel_iofactory::createreader($inputfiletype);  /**  read list of worksheet names , select 1 want load  **/ $worksheetlist = $objreader->listworksheetnames($inputfilename) $sheetname = $worksheetlist[0];   /**  advise reader of worksheets want load  **/  $objreader->setloadsheetsonly($sheetname);  /**  load $inputfilename phpexcel object  **/  $objphpexcel = $objreader->load($inputfilename);