Prev
Helper |
ExcelExplorer Manual |
Next
Type |
 |
Chapter 15. EEWorksheet class
Class EEWorksheet
(ExcelExplorer 4.0)
Class to operate worksheets. The worksheet can be defined (stored in Excel file) or undefined (no worksheet have been created in Excel).
Use Defined() method to distinguish these worksheets.
Worksheet can be defined (have type, title, etc.), but have no data. Such worksheets considered as empty (see IsEmpty() method).
Object of this class returned by
ExcelExplorer::Worksheet - Get EEWorksheet object for the specified worksheet
Methods
Type - Get worksheet type
Title - Get worksheet title
Hidden - Returns worksheet visibility
Defined - Returns whether worksheet is defined (exists) or not
IsEmpty - Returns whether worksheet exists and contains any data or not
false DefinedArea - Returns defined area in the current sheet (area contains defined columns, rows, or cells - even blank)
false UsedArea - Returns used area in the current sheet (area contains cells with data)
Column - Get EEColumn object for the specified column
Row - Get EERow object for the specified row
Cell - Get EECell object for the specified cell
ShapesNum - Returns number of shapes defined in the worksheet
false Shape - Get EEShape object for the specified shape
| 
