Prev
ExploreWorksheet |
ExcelExplorer Manual |
Next
Worksheet |
 |
(ExcelExplorer 4.0)
Returns number of defined worksheets.
integer WorksheetsNum( )
Parameters
- None
Description
Returns number of worksheets defined in an Excel file.
Counts only defined worksheets. If 0 returned that no worksheets defined.
Please note that this is not indicate that all of these worksheets contains
data (i.e. some cells defined). To determine if worksheet is empty or not
EEWorksheet()->IsEmpty() can be used.
Print all worksheets types
<?php
$n = $ee->WorksheetsNum();
for( $i=0; $i<$n; $i++ ) {
echo ($i+1).' - ';
if( $ee->Worksheet($i)->IsEmpty() ) {
echo 'Empty worksheet';
} else {
switch( $ee->Worksheet($i)->Type() ) {
case EE_SHEET_NORMAL:
echo 'Worksheet';
break;
case EE_SHEET_CHART:
echo 'Chart';
break;
case EE_SHEET_VB:
echo 'Visual Basic module';
break;
default:
echo 'Unknown';
break;
}
}
echo "\n";
}
?>
| 
