表達代表Worksheet 物件的變數。 範例 本範例保護使用中工作表,然後決定是否可在保護工作表上插入欄,並將此狀態通知使用者。 VB SubCheckProtection() ActiveSheet.Protect' Check the ability to insert columns on a protected sheet.' Notify the user of this status.IfActiveSheet.Protection.AllowInsertingColumns ...
返回一个 Protection 对象,该对象代表工作表的保护选项。语法表达式。保护表达 一个代表 Worksheet 对象的变量。示例本示例对活动工作表进行保护,并判断是否能在受保护的工作表中插入列,然后将此状态通知用户。VB 复制 Sub CheckProtection() ActiveSheet.Protect ' Check the ability to insert columns on a ...
保护worksheet。 如果工作表已受保护,则失败。 TypeScript 复制 protect(options?: Excel.WorksheetProtectionOptions, password?: string): void; 参数 options Excel.WorksheetProtectionOptions 可选。 工作表保护选项。 password string 可选。 工作表保护密码。 返回 void 注解 [ API set: ExcelApi 1.2 for...
let protectionOptions : ExcelScript.WorksheetProtectionOptions = { selectionMode: ExcelScript.ProtectionSelectionMode.none } // Apply the given protection options. sheetProtection.protect(protectionOptions); } Properties展開表格 allowAutoFilter Represents the worksheet protection option allowing use of t...
publicMicrosoft.Office.Interop.Excel.Protection Protection {get; } Property Value Protection AProtectionobject that represents the protection options of the worksheet. Applies to उत्पादसंस्करण Visual Studio Tools for Office2017, 2019, 2022 ...
WorksheetFilteredEventArgs WorksheetFormatChangedEventArgs WorksheetFormulaChangedEventArgs WorksheetFreezePanes WorksheetMovedEventArgs WorksheetNameChangedEventArgs WorksheetProtection WorksheetProtectionChangedEventArgs WorksheetProtectionOptions WorksheetRowHiddenChangedEventArgs WorksheetRowSortedEventArgs WorksheetSearchCriteria Works...
Worksheet level protection is not intended as a security feature. It simply prevents users from modifying locked cells within the worksheet. Following are the different options available for protecting your Excel data: File-level: This refers to the ability to lock down your Excel file by specifyin...
Gets a Protection object that represents the protection options of the worksheet. C# 复制 public Microsoft.Office.Interop.Excel.Protection Protection { get; } Property Value Protection A Protection object that represents the protection options of the worksheet. Applies to 产品版本 Visual Studio ...
C# publicMicrosoft.Office.Interop.Excel.Protection Protection {get; } Property Value Protection AProtectionobject that represents the protection options of the worksheet. Applies to 产品版本 Visual Studio Tools for Office2017, 2019, 2022
The protection is not enforced on unlocked cells. Also, the advanced options available in WorksheetProtection are only supported in XLSX and XLS file formats. Additionally, the ability to edit specific objects within the worksheet is limited to XLSX files. To remove protection from a protected ...