Represents a range of cells in a worksheet that may be edited by the end user.
Constructors
Section titled "Constructors"WorksheetProtectedRange
new WorksheetProtectedRange(title: string): WorksheetProtectedRangeReturns WorksheetProtectedRange
Properties
Section titled "Properties"$t: TypeAccessors
Section titled "Accessors"hasPassword
Section titled "hasPassword"Returns true if the range has a password associated with it.
get hasPassword(): boolean
Returns boolean
isProtected
Section titled "isProtected"Returns a boolean indicating if the range is currently locked.
get isProtected(): boolean
Returns boolean
set isProtected(a: boolean): voidParameters
- a:
boolean
Returns void
ranges
Section titled "ranges"Returns a collection of ranges that may be edited when the worksheet is protected.
get ranges(): ICollection$1<WorksheetRegion>
Returns ICollection$1<WorksheetRegion>
title
Section titled "title"Returns or sets the name of the range.
get title(): string
Returns string
set title(a: string): voidParameters
- a:
string
Returns void
worksheet
Section titled "worksheet"Returns the worksheet with which the edit range is associated.
get worksheet(): Worksheet
Returns Worksheet
Methods
Section titled "Methods"unprotect
Section titled "unprotect"Removes the password from the range.
unprotect(): void