Working with Multiple Sheets

The component allows multiple sheets. Set the Count property to specify the number of sheets. For information on adding sheets with the designer, see the SheetView Collection Editor.

For information about the display of the sheet names in the sheet name buttons, refer to Displaying the Sheet Names.

Formulas in a cell on one sheet can refer to a value or a cell on another sheet. For more information about formulas, refer to Managing Formulas.

You can name the sheets. Use the SheetName property in the SheetView class to name the sheet programmatically.

For information about adding a sheet, refer to Adding a Sheet.

Using Code

This example sets the number of sheets.

C#	Copy Code
FpSpread1.Sheets.Count = 2;

VB	Copy Code
FpSpread1.Sheets.Count = 2