# SHEETS

Spread for WinForms provides advanced software components that support Excel import/export, full cell customization, an extensive calculation engine with over 450 functions and more, all with zero dependencies on Excel.

## Content



This function returns the number of sheets in a reference.

## Syntax

SHEETS(*ref*)

## Arguments

For the argument, the reference for which you want to know the number of sheets. This argument is optional.

## Remarks

The #REF! error value is returned if the reference is not a valid value. The total number of sheets in the workbook is returned if no parameter is listed.

## Data Types

Accepts string data. Returns numeric data.

## Examples

`SHEETS(Products)` gives the result 2.

## Version Available

This function is available in Spread for Windows Forms 11.0 or later.