Previous topicNext topic
Help > 开发指南 > Excel > API > 示例 > 保护 >
如何：保护工作簿

下面的示例演示如何使用 Workbook.Protect 方法保护整个工作簿。工作簿保护可防止最终用户修改工作簿结构（通过移动、删除、添加、重命名或隐藏现有工作表，或显示隐藏的工作表）。

Vb.Net
'创建一个Workbook工作簿对象.
Dim workbook As New DevExpress.Spreadsheet.Workbook()
Dim worksheet As DevExpress.Spreadsheet.Worksheet = workbook.Worksheets("ProtectionSample")
workbook.Worksheets.ActiveWorksheet = worksheet

' 使用密码保护工作簿结构（防止用户添加或删除工作表或显示隐藏的工作表）。
If Not workbook.IsProtected Then
    workbook.Protect("password", True, False)
End If
'添加一个备注信息.
worksheet("B2").Value = "Workbook structure is protected with a password. " & ControlChars.Lf & " You cannot add, move or delete worksheets until protection is removed."
worksheet.Visible = True

C#
// 创建一个Workbook工作簿对象.
DevExpress.Spreadsheet.Workbook workbook = new DevExpress.Spreadsheet.Workbook();
DevExpress.Spreadsheet.Worksheet worksheet = workbook.Worksheets["ProtectionSample"];
workbook.Worksheets.ActiveWorksheet = worksheet;

// 使用密码保护工作簿结构（防止用户添加或删除工作表或显示隐藏的工作表）。
if (!workbook.IsProtected)
    workbook.Protect("password", true, false);
// 添加一个备注信息.
worksheet["B2"].Value = "Workbook structure is protected with a password. " + ControlChars.Lf + " You cannot add, move or delete worksheets until protection is removed.";
worksheet.Visible = true;


取消保护工作簿

若要删除保护，请使用 Workbook.Unprotect 方法。

Vb.Net
'创建一个Workbook工作簿对象.
Dim workbook As New DevExpress.Spreadsheet.Workbook()
Dim worksheet As DevExpress.Spreadsheet.Worksheet = workbook.Worksheets("ProtectionSample")
workbook.Worksheets.ActiveWorksheet = worksheet

' 使用密码解除工作簿的密码保护.
If workbook.IsProtected Then
    workbook.Unprotect("password")
End If
'添加一个备注
worksheet("B2").Value = "Workbook is unprotected. Workheets can be added, moved or deleted."
worksheet.Visible = True

C#
// 创建一个Workbook工作簿对象.
DevExpress.Spreadsheet.Workbook workbook = new DevExpress.Spreadsheet.Workbook();
DevExpress.Spreadsheet.Worksheet worksheet = workbook.Worksheets["ProtectionSample"];
workbook.Worksheets.ActiveWorksheet = worksheet;

// 使用密码保护工作簿结构（防止用户添加或删除工作表或显示隐藏的工作表）。
if (workbook.IsProtected)
    workbook.Unprotect("password");
// 添加一个备注信息.
worksheet["B2"].Value = "Workbook is unprotected. Workheets can be added, moved or deleted.";
worksheet.Visible = true;