WorkBookProtection

WorkBookProtection

返回一个 WorkBookProtection 对象， 该对象用于设置WorkBook的结构保护

属性

isProtected

工作簿是否开启保护

语法

Application.ActiveWorkbook.Protection.isProtected

Application：表格应用对象

返回值

isProtected : boolean

示例

async function example() {
  const Protection = Application.ActiveWorkbook.Protection;
  const isProtected = Protection.isProtected;
  console.log(isProtected);
}

方法

protect

开启工作簿结构保护

语法

Application.ActiveWorkbook.Protection.protect()

Promise<void>

示例

async function example() {
  const success = await Application.ActiveWorkbook.Protection.protect();
}

unprotect

撤销工作簿结构保护

语法

Application.ActiveWorkbook.Protection.unprotect()

返回值

Promise<void>

示例

async function example() {
  const success = await Application.ActiveWorkbook.Protection.unprotect();
}

getProtected()

获取当前工作簿结构保护是否开启

语法

Application.ActiveWorkbook.Protection.getProtected()

返回值

Promise<boolean>

示例

async function example() {
  const isProtected = await Application.ActiveWorkbook.Protection.getProtected();
  console.log(isProtected);
}