how to know number of last spreadsheet???

Mar 4, 2012 at 1:38 PM
Edited Mar 4, 2012 at 3:19 PM

Hi.

First, sorry for my English.

I wonder, how I can know, how many worksheets are in an Excel file. In another project in which I use another script had a function to know, but now we are using xlsx, and don´t know how to tell the script where is the last worksheet.

Thank you ..

Coordinator
Mar 4, 2012 at 8:39 PM
$objPHPExcel->getSheetCount();

will return the number of worksheets: sheets are numbered from 0 onwards

$objPHPExcel->getSheetNames();

will return an array of the sheet names, you could also count() that.

 

 

 

Mar 5, 2012 at 6:46 PM
Edited Mar 5, 2012 at 6:47 PM

Thank you very much. I'll try.

Greetings ..