Customizing the Appearance of the Sheet

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:

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.