SpreadJS 15
Formula Reference / Formula Functions / Information Functions / SHEETS
In This Topic
    SHEETS
    In This Topic

    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

    Data Types

    Returns the number of sheets in a reference.

    Examples

    =SHEETS(My3DRef)