ITabSheet Interface |
Represents an Excel worksheet Tab.
Namespace: Spire.Xls.Core
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
The ITabSheet type exposes the following members.
Properties
| Name | Description | |
|---|---|---|
|
CheckBoxes |
Returns collection with all checkboxes inside this worksheet. Read-only.
|
|
|
CodeName |
Name used by macros to access workbook items. Read-only.
|
|
|
ComboBoxes |
Returns collection with all comboboxes inside this worksheet. Read-only.
|
|
|
IsPasswordProtected |
Indicates if the worksheet is password protected.
|
|
|
IsRightToLeft |
Indicates whether worksheet is displayed right to left.
|
|
|
IsSelected |
Indicates whether tab of this sheet is selected. Read-only.
|
|
|
Name |
Gets / sets name of the tab sheet.
|
|
|
Parent |
Gets the parent object of the current instance.
(Inherited from
IExcelApplication
.)
|
|
|
Pictures |
Returns pictures collection. Read-only.
|
|
|
ProtectContents |
Indicates is current sheet is protected.
|
|
|
ProtectDrawingObjects |
True if objects are protected. Read-only.
|
|
|
Protection |
Gets protected options. Read-only. For sets protection options use "Protect" method.
|
|
|
ProtectScenarios |
True if the scenarios of the current sheet are protected. Read-only.
|
|
|
RadioButtons |
Returns collection with all option buttons inside this worksheet. Read-only.
|
|
|
TabColor |
Gets / sets tab color.
|
|
|
TabIndex |
Returns index in the parent ITabSheets collection. Read-only.
|
|
|
TabKnownColor |
Gets / sets tab color.
|
|
|
TextBoxes |
Returns collection with all textboxes inside this worksheet. Read-only.
|
|
|
Visibility |
Control visibility of worksheet to end user.
|
|
|
Workbook |
Returns parent workbook. Read-only.
|
Methods
| Name | Description | |
|---|---|---|
|
Activate |
Makes the current sheet the active sheet. Equivalent to clicking the
sheet's tab.
|
|
|
Protect(String) |
Protects worksheet's content with password.
|
|
|
Protect(String, SheetProtectionType) |
Protects current worksheet.
|
|
|
Select |
Selects current tab sheet.
|
|
|
Unprotect |
Unprotects worksheet's content with password.
|
|
|
Unselect |
Unselects current tab sheet.
|
See Also
