Sheet

Base class for a sheet in a Microsoft Excel workbook.

Constructors

new Sheet(a: string, b: Workbook, c: number): Sheet

$t: Type

Returns a boolean indicating if the Sheet has been protected with a password.

get hasProtectionPassword(): boolean

Returns boolean

Returns a boolean indicating if the Worksheet has been protected.

get isProtected(): boolean

Returns boolean

Gets or sets the sheet name.

get name(): string

Returns string

set name(a: string): void

Returns void

Gets the value which indicates whether this worksheet is selected.

get selected(): boolean

Returns boolean

Gets the zero-based index of this sheet in its parent [[Workbook.sheets]] collection.

get sheetIndex(): number

Returns number

Gets or sets the [[WorkbookColorInfo]] to use for the associated sheet's tab in the tab bar of Microsoft Excel.

get tabColorInfo(): WorkbookColorInfo

set tabColorInfo(a: WorkbookColorInfo): void

Returns void

Returns a value indicating the type of sheet

get type(): SheetType

Returns SheetType

Gets the [[workbook]] that owns the worksheet. The Workbook that owns the worksheet.

get workbook(): Workbook

Returns Workbook

Moves the sheet to a new position in the owning workbook's collections of sheets.

moveToSheetIndex(index: number): void

Removes the Sheet protection.

unprotect(): void

staticInit(): void