You can have multiple sheets within a workbook. Each sheet is a separate spreadsheet and can have its own appearance and settings for user interaction. Each sheet has a unique name and sheet name tab for easy navigation between sheets.
These tasks relate to setting the appearance of the entire sheet inside the Spread component:
- Working with the Active Sheet
- Working with Multiple Sheets
- Adding a Sheet
- Copying and Inserting a Sheet
- Moving a Sheet
- Removing a Sheet
- Showing or Hiding a Sheet
When you work with sheets, you can manipulate the objects using the short cuts in code, (SheetView and SheetViewCollection classes) or you can directly manipulate the model. Most developers who are not changing anything drastically find it easy to manipulate the short cut objects. For more information on models, refer to Understanding the Underlying Models.
Settings applied to a particular row or column or cell can override the settings that are set at sheet level. Refer to Object Parentage.
For more details on the objects involved, refer to the SheetView class and SheetViewCollection class.