The component allows multiple sheets. You can specify the number of sheets with the Count property of the SheetViewCollection class. For example, you can set the Spread to have 5 sheets (and each sheet has a sheet name tab) using this code.

fpSpread1.Sheets.Count = 5;

FpSpread1.Sheets.Count = 5

You can set the properties of each sheet in code by using ActiveSheet property of the SheetView or FpSpread class.

You can name the sheets or use the default sheet names. The default sheet name is "Sheet1" and as other sheets are added, the sheet are named incrementally "Sheet2", "Sheet3", and so on. Use the SheetName property of the SheetView class to name the sheet programmatically.The addition and removal of sheets are described below.

• Add a sheet
• Remove a sheet

The Sheets property of the FpSpread class returns a SheetViewCollection object that holds all the sheets of the control.In the Sheets property, specify an integer starting with "0" as an index to refer to a specific sheet.

The following sample code copies the sheet with the index "1" of the fpSpread1 control (second sheet) to the sheet with the index "0" of the fpSpread2 control (the first sheet).Since both refer to the same SheetView object in this sample code, changes made to one sheet gets reflected to the other sheet as well.

fpSpread2.Sheets[0] = fpSpread1.Sheets[1];

FpSpread2.Sheets(0) = FpSpread1.Sheets(1)

To return a sheet by name, you can use the Find method of the SheetViewCollection class as shown in the following code.

fpSpread1.Sheets.Find("Sheet1").Cells[0, 0].Value = "test";

FpSpread1.Sheets.Find("Sheet1").Cells(0, 0).Value = "test"

For information about the display of the sheet names, kindly refer to "Customizing the Sheet Name Tabs".