You can set many different properties for the appearance of the data area of the spreadsheet.
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 component:
- Working with the Active Sheet
- Working with Multiple Sheets
- Adding a Sheet
- Removing a Sheet
- Showing or Hiding a Sheet
- Setting the Background Color of the Sheet
- Adding a Title and Subtitle to a Sheet
- Customizing the Page Size (Rows to Display)
- Displaying Grid Lines on the Sheet
- Customizing the Sheet Corner
- Displaying a Footer for Columns or Groups
You can quickly customize the appearance of a sheet by applying a "skin" to it. Skins are provided with Spread to create common formats. You can also create your own skin and save it, to use again, similar to a template.
Note: Be aware that some settings for skins are affected by the setting of the EnableClientScript property of the component.
The tasks you can perform when working with skins include:
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 the sheet properties, refer to the SheetView class.
For more information on the SheetView collection editor, refer to SheetView Collection Editor.
For information on displaying the sheet names, refer to Displaying the Sheet Names.
Return to the appearance overview at Customizing the Appearance.