SHEETS | SpreadJS 15

SHEETS

In This Topic

This function returns the number of sheets in a reference.

SHEETS(reference)

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.

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.

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.

Returns the number of sheets in a reference.

=SHEETS(My3DRef)