Chapter 14. 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

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