- SpreadJS Overview
- Getting Started
- JavaScript Frameworks
- Best Practices
- Features
- SpreadJS Designer
- SpreadJS Designer Component
- Touch Support
-
Formula Reference
- Formula Overview
-
Formula Functions
- Barcode Functions
- Compatibility Functions
- Database Functions
- Date and Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Logical Functions
- Lookup and Reference Functions
- Math and Trigonometric Functions
- Statistical Functions
- Sparkline Functions
- Text Functions
- Web Functions
- Other Functions
- RegEx Functions
- Import and Export Reference
- Frequently Used Events
- API Documentation
- Release Notes
SHEETS
This function returns the number of sheets in a reference.
Syntax
SHEETS(reference)
Arguments
Argument | Description |
|---|---|
Reference | (Optional) Reference is a reference for which you want to know the number of sheets it contains.If the reference is omitted, the function returns the number of sheets in the workbook that contains the function. |
Remarks
This function includes all worksheets (visible, hidden, or very hidden) in addition to all other sheet types (macro, chart, or dialog sheets).
If reference is not a valid value, this function returns the #REF! error value.
Data Types
Returns the number of sheets in a reference.
Examples
=SHEETS(My3DRef)