constructor

• new WorksheetProtectedRangeCollection(a): WorksheetProtectedRangeCollection

• Parameters

  • a: Worksheet

  Returns WorksheetProtectedRangeCollection

Static $t

count

• get count(): number

• Gets the number of ranges in the collection.

  Returns number

[iterator]

• [iterator](): EnumeratorWrapper<WorksheetProtectedRange>

• Returns EnumeratorWrapper<WorksheetProtectedRange>

add

• add(item): void

• Adds the specified range to the collection.

  Parameters

  • item: WorksheetProtectedRange

    The range to be added

  Returns void

clear

• clear(): void

• Clears all ranges from the collection.

  Returns void

contains

• contains(range): boolean

• Determines whether a range is in the collection.

  Parameters

  • range: WorksheetProtectedRange

    The range to locate in the collection.

  Returns boolean

getEnumerator

• getEnumerator(): IEnumerator$1<WorksheetProtectedRange>

• Gets an enumerator which can iterator all ranges in the collection.

  Returns IEnumerator$1<WorksheetProtectedRange>

insert

• insert(index, range): void

• Inserts the specified range in the collection.

  Parameters

  • index: number

    The 0-based index in the collection where the range should be inserted.

  • range: WorksheetProtectedRange

    The range to insert in the collection.

  Returns void

item

• item(a): WorksheetProtectedRange

• Gets the range at the specified index in the collection. The range at the specified index.

  Throws

  [[ArgumentOutOfRangeException]] 'index' is less than zero or 'index' is greater than or equal to [[count]].

  Parameters

  • a: number

  Returns WorksheetProtectedRange

remove

• remove(range): boolean

• Removes the specified range from the collection.

  Parameters

  • range: WorksheetProtectedRange

    The range to remove from the collection.

  Returns boolean

removeAt

• removeAt(index): void

• Removes the range at the specified index from the collection.

  Throws

  [[ArgumentOutOfRangeException]] 'index' is less than zero or 'index' is greater than or equal to [[count]].

  Parameters

  • index: number

    The index of the range to remove from the collection.

  Returns void