保护 Excel 文件

VBC#

using IronXL;

WorkBook workBook = WorkBook.Load("sample.xlsx");
WorkSheet workSheet = workBook.DefaultWorkSheet;

// Open protected spreadsheet file
WorkBook protectedWorkBook = WorkBook.Load("sample.xlsx", "IronSoftware");

// Spreadsheet protection
// Set protection for spreadsheet file
workBook.Encrypt("IronSoftware");

// Remove protection for spreadsheet file. Original password is required.
workBook.Password = null;

workBook.Save();

// Worksheet protection
// Set protection for individual worksheet
workSheet.ProtectSheet("IronXL");

// Remove protection for particular worksheet. It works without password!
workSheet.UnprotectSheet();

workBook.Save();

Imports IronXL

Dim workBook As WorkBook = WorkBook.Load("sample.xlsx")
Dim workSheet As WorkSheet = workBook.DefaultWorkSheet

' Open protected spreadsheet file
Dim protectedWorkBook As WorkBook = WorkBook.Load("sample.xlsx", "IronSoftware")

' Spreadsheet protection
' Set protection for spreadsheet file
workBook.Encrypt("IronSoftware")

' Remove protection for spreadsheet file. Original password is required.
workBook.Password = Nothing

workBook.Save()

' Worksheet protection
' Set protection for individual worksheet
workSheet.ProtectSheet("IronXL")

' Remove protection for particular worksheet. It works without password!
workSheet.UnprotectSheet()

workBook.Save()

PM > Install-Package IronXL.Excel

Install-Package IronXL.Excel

保护 Excel 文件

IronXL的Encrypt方法为开发者提供了为整个Excel工作簿和单个工作表应用密码保护的能力。此功能对于保护敏感数据至关重要，并确保只有授权用户才能访问或修改 Excel 文件的内容。

IronXL 还允许进行工作表级别的保护，从而防止用户编辑工作簿的某些部分或特定工作表。这在协作环境中尤其有用，因为你可能希望限制编辑权限，但仍然允许用户查看数据或与数据进行交互。此外，无论是否使用密码，都可以选择移除保护，这提供了灵活性，使其既适用于安全环境，也适用于需要临时恢复访问权限的情况。总而言之，此功能是确保自动化数据处理工作流程中 Excel 文件安全的重要工具。