GrapeCity.Spreadsheet.ISheet

ISheet Interface

Represents a sheet in the workbook.

public interface ISheet

Public Interface ISheet

Name	Description
Buttons	Gets the list of button controls of this IWorksheet.
CheckBoxes	Gets the list of check box controls of this IWorksheet.
DropDowns	Gets the list of combo box controls of this IWorksheet.
GroupBoxes	Gets the list of group box controls of this IWorksheet.
Index	Gets an integer value that represents the index number of the sheet within the collection.
Labels	Gets the list of label controls of this IWorksheet.
ListBoxes	Gets the list of list box controls of this IWorksheet.
Name	Gets or sets a string value representing the name of the sheet.
Next	Gets an ISheet object that represents the next sheet.
OptionButtons	Gets the list of option button controls of this IWorksheet.
PageSetup	Gets the page setup of the sheet.
Previous	Gets an ISheet object that represents the previous sheet.
ProtectDrawingObjects	Gets a boolean value indicating whether shapes are protected.
ProtectionMode	Gets a value indicates whether user-interface-only protection is turned on. To turn on user interface protection, use the Protect(WorksheetLocks, string) method.
ScrollBars	Gets the list of scroll bar controls of this IWorksheet.
Spinners	Gets the list of spin button controls of this IWorksheet.
TabColor	Gets or sets the color of the tab.
Type	Gets the worksheet type.
View	Gets the worksheet view of this ISheet object.
Visible	Gets or sets a SheetVisibility value that determines whether the sheet is visible.
Workbook	Gets the Workbook object contains current IWorksheet object.

Name	Description
Activate()	Makes the current sheet the active sheet.
Copy(int)	Copies this ISheet to the specified position in the ISheet collection of the IWorkbook.
Delete()	Deletes this ISheet from its owner IWorkbook.
Move(int)	Moves this ISheet to the specified position in the ISheet collection of the IWorkbook.
Protect(string)	Protects a sheet so that it cannot be modified.
SaveAs(Stream, FileFormat, string, ExportOptions)	Saves this IWorksheet to the specified Stream.
SaveAs(string, FileFormat, string, ExportOptions)	Saves this IWorksheet to the specified file location.
Select(bool)	Selects the sheet.
Unprotect(string)	Unprotects the sheet which is protected by password.