Spread for ASP.NET 8.0 Product Documentation > Developer's Guide > Customizing the Appearance > Customizing the Appearance of the Sheet > Removing a Sheet |
You can remove a sheet or several sheets from the component. The sheet index is zero-based. In code, you can simply change the number of sheets using the Count property or you can explicitly remove the sheet(s) using the Remove method.
Removing an existing sheet does not change the default sheet names provided to the other sheets. For example, a component with three sheets would by default name them Sheet1, Sheet2, and Sheet3. If you remove the second sheet, the names for the remaining sheets are Sheet1 and Sheet3. The indexes for the sheets are 0 and 1, because the sheet index is zero-based. You can also hide a sheet. For more information, refer to Showing or Hiding a Sheet.To remove an existing sheet, complete the following instructions.
For information on adding a sheet, refer to Adding a Sheet.
Use the Remove method with the FpSpread component Sheets shortcut to remove the SheetView object from the collection of sheets (SheetViewCollection).
This example code removes the second sheet from a component that has two or more sheets.
C# |
Copy Code
|
---|---|
// Remove the second sheet.
FpSpread1.Sheets.Remove(FpSpread1.Sheets[1]);
|
VB |
Copy Code
|
---|---|
' Remove the second sheet.
FpSpread1.Sheets.Remove(FpSpread1.Sheets(1))
|