Skip to main content

AllowEditRange

Excel.AllowEditRange: one <protectedRange>; the title is its key. Import from @reductoai/xlsx/officejs.

AllowEditRange properties

AllowEditRange.delete()

AllowEditRange.pauseProtection()

Lets this range be edited for the session; the file keeps the protection.

AllowEditRange.set()

AllowEditRange.setPassword()

An empty or missing password removes it.

AllowEditRangeCollection

Excel.AllowEditRangeCollection: the sheet’s <protectedRanges>. Import from @reductoai/xlsx/officejs.

AllowEditRangeCollection properties

AllowEditRangeCollection.add()

AllowEditRangeCollection.getCount()

AllowEditRangeCollection.getItem()

AllowEditRangeCollection.getItemAt()

AllowEditRangeCollection.getItemOrNullObject()

AllowEditRangeCollection.pauseProtection()

Pauses every range with this password; throws when none has it.

ExcelCommentReplyCollection

Excel.CommentReplyCollection of one comment. Import from @reductoai/xlsx/officejs.

ExcelCommentReplyCollection properties

ExcelCommentReplyCollection.add()

ExcelCommentReplyCollection.getCount()

ExcelCommentReplyCollection.getItem()

ExcelCommentReplyCollection.getItemAt()

ExcelCommentReplyCollection.getItemOrNullObject()

WorkbookProtection

Excel.WorkbookProtection: <workbookProtection lockStructure>. Import from @reductoai/xlsx/officejs.

WorkbookProtection properties

WorkbookProtection.protect()

Locks the sheet structure; throws when it is already locked.

WorkbookProtection.unprotect()