ExcelExplorer Pro Manual
Next
List of all available classes
III. Class Reference
12.
List of all available classes
13.
ExcelExplorer class
14.
EEWorksheet class
15.
EEColumn class
16.
EERow class
17.
EECell class
18.
EEData class
19.
EEDataRichText class
20.
EEDataPhonetic class
21.
EEStyle class
22.
EEFont class
23.
EEFormat class
24.
EEColor class
25.
EEAlign class
26.
EEBorders class
27.
EEBorder class
28.
EEArea class
29.
EELink class
30.
EEImage class
31.
EEShape class
32.
EEHelper class
This section contains detailed information about individual classes.
NOTES
- In all examples used the following assumptions:
$ee - object, created instance of ExcelExplorer class and
Excel file successfully readed using ExploreFile() or ExploreString() functions
(description of these methods also contains detailed information of all available options and how to use it).
- If method not marked with any sign you can assume than it will always returns valid object/value.
- Methods marked with false can returns FALSE instead of valid objects when specific data not available (not defined in Excel file, file corrupted, etc.) or corresponding option is set to FALSE.
For instance, setting read_border to FALSE will cause EEStyle->Borders() always returns FALSE instead of valid EEBorders object.
You should always check returning value of this methods before using it as objects.
Marks used only for methods which returns objects in order to easily understands when PHP5 ability to call $obj->method1()->method2() can be used and when you must check what returns $obj->method1() before calling method2().
- If read_only_sheets_info option is set to TRUE then ony worksheet-related methods can be used.
- More detailed information you can find in method description.
The following examples helps you understand how to write correct code.
1. For non-marked methods:
$ee = new ExcelExplorer();
// ... some code
print $ee->Cell($sheet,$col,$row)->Data()->UTF8();
2. For methods marked with false :
$ee = new ExcelExplorer();
// ... some code
if( $font = $ee->Cell($sheet,$col,$row)->Style()->Font() ) {
print $font->Name()->UTF8();
Next
List of all available classes
