Prev
EEWorksheet class |
ExcelExplorer Manual |
Next
Title |
 |
(ExcelExplorer 4.0)
Get worksheet type.
integer Type( )
Parameters
- None
Description
Returns worksheet type. Currently returns one of the following values:
| Worksheet Type |
Description |
| EE_SHEET_NORMAL |
Ordinary worksheet. Also returns for undefined worksheets.
To check if worksheet is defined use EEWorksheet->Defined() method.
To check if worksheet is empty use EEWorksheet->IsEmpty() method. |
| EE_SHEET_CHART |
Chart. |
| EE_SHEET_VB |
Visual Basic module. |
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";
}
?>
| 
