Sheet

Base class for a sheet in a Microsoft Excel workbook.

Constructors

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

$t: Type

name: string

tabColorInfo: WorkbookColorInfo

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 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

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