如何在 C# 中为工作簿设置密码

Updated: 2026年6月4日

IronXL允许开发人员通过一次方法调用在C#中为Excel工作簿设置密码保护——使用Encrypt方法设置所需密码并保存工作簿以立即应用保护。

快速入门：使用IronXL加密工作簿密码

IronXL 只需一个简单的步骤即可让开发人员加密 Excel 工作簿——无需互操作，轻松便捷。使用Encrypt方法设置您的密码并保存文件以立即保护您的工作簿。

1Install IronXL with NuGet Package Manager
PM > Install-Package IronXL.Excel
```
Install-Package IronXL.Excel
```

2复制并运行这段代码。

var wb = WorkBook.Load("input.xlsx"); wb.Encrypt("MyStrongPass"); wb.SaveAs("input.xlsx");

var wb = WorkBook.Load("input.xlsx"); wb.Encrypt("MyStrongPass"); wb.SaveAs("input.xlsx");

3部署到您的生产环境中进行测试

通过免费试用立即在您的项目中开始使用IronXL

最小工作流程（5 个步骤）

IronXL C# 库指南，展示通过安装命令为 Excel 工作簿设置密码保护的 5 个步骤

下载用于密码保护工作簿的 C# 库
访问受密码保护的工作簿
对工作簿应用密码保护
移除工作簿的密码保护
导出加密的工作簿

如何访问受密码保护的工作簿？

通过将密码作为Load方法的第二个参数传递，可以打开一个受保护的电子表格。例如：WorkBook.Load("sample.xlsx", "IronSoftware")。在使用由同事或自动化流程保护的现有 Excel 文件时，该功能至关重要。

请注意: 没有正确密码无法打开受保护的电子表格

下面是一个完整的示例，演示如何访问受密码保护的工作簿：

using IronXL;

// Attempt to open a password-protected workbook
try 
{
    WorkBook protectedWorkBook = WorkBook.Load("encrypted_data.xlsx", "MySecretPass123!");
    
    // Access the first worksheet
    WorkSheet sheet = protectedWorkBook.WorkSheets[0];
    
    // Read data from protected file
    var cellValue = sheet["A1"].Value;
    Console.WriteLine($"Successfully accessed protected workbook. A1 contains: {cellValue}");
}
catch (Exception ex)
{
    Console.WriteLine($"Failed to open workbook: {ex.Message}");
}

using IronXL;

// Attempt to open a password-protected workbook
try 
{
    WorkBook protectedWorkBook = WorkBook.Load("encrypted_data.xlsx", "MySecretPass123!");
    
    // Access the first worksheet
    WorkSheet sheet = protectedWorkBook.WorkSheets[0];
    
    // Read data from protected file
    var cellValue = sheet["A1"].Value;
    Console.WriteLine($"Successfully accessed protected workbook. A1 contains: {cellValue}");
}
catch (Exception ex)
{
    Console.WriteLine($"Failed to open workbook: {ex.Message}");
}

Imports IronXL

' Attempt to open a password-protected workbook
Try
    Dim protectedWorkBook As WorkBook = WorkBook.Load("encrypted_data.xlsx", "MySecretPass123!")

    ' Access the first worksheet
    Dim sheet As WorkSheet = protectedWorkBook.WorkSheets(0)

    ' Read data from protected file
    Dim cellValue = sheet("A1").Value
    Console.WriteLine($"Successfully accessed protected workbook. A1 contains: {cellValue}")
Catch ex As Exception
    Console.WriteLine($"Failed to open workbook: {ex.Message}")
End Try

Imports IronXL

' Attempt to open a password-protected workbook
Try
    Dim protectedWorkBook As WorkBook = WorkBook.Load("encrypted_data.xlsx", "MySecretPass123!")

    ' Access the first worksheet
    Dim sheet As WorkSheet = protectedWorkBook.WorkSheets(0)

    ' Read data from protected file
    Dim cellValue = sheet("A1").Value
    Console.WriteLine($"Successfully accessed protected workbook. A1 contains: {cellValue}")
Catch ex As Exception
    Console.WriteLine($"Failed to open workbook: {ex.Message}")
End Try

如果我用错密码会怎样？

当提供的密码不正确时，IronXL 会抛出异常，而不是返回空值或空工作簿。这种行为可以防止未经授权的访问尝试，从而确保安全性。始终用 try-catch 块封装受密码保护的工作簿操作，以便从容应对身份验证失败。如果您正在构建一个处理多个 Excel 文件的应用程序，请考虑实施重试机制，并在输入密码时进行用户提示。

我能否在打开工作簿之前检查其是否受密码保护？

遗憾的是，Excel 的文件格式不允许在不尝试打开文件的情况下检查密码保护状态。建议的方法是先尝试在没有密码的情况下加载文件，然后捕捉异常并在需要时使用密码重试。当管理具有混合保护级别的多个工作表时，这种模式非常有效。

如何在工作簿中应用密码？

要为电子表格设置密码保护，请根据下面的代码示例使用Encrypt方法。

WorkBook workBook = WorkBook.Load("sample.xlsx");

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

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

workBook.Save();

WorkBook workBook = WorkBook.Load("sample.xlsx");

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

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

workBook.Save();

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

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

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

workBook.Save()

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

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

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

workBook.Save()

对于更高级的应用场景，您可以将工作簿加密与工作表级保护相结合：

using IronXL;
using System;

// Create a new workbook with sensitive financial data
WorkBook workBook = WorkBook.Create(ExcelFileFormat.XLSX);
WorkSheet sheet = workBook.CreateWorkSheet("FinancialData");

// Add sensitive data
sheet["A1"].Value = "Confidential Financial Report";
sheet["A3"].Value = "Revenue";
sheet["B3"].Value = 1250000;
sheet["A4"].Value = "Expenses";
sheet["B4"].Value = 750000;

// Apply formatting before encryption
sheet["B3:B4"].FormatString = "$#,##0.00";

// Encrypt the workbook with a strong password
workBook.Encrypt("F!n@nc3_S3cur3_2024");

// Save the encrypted workbook
workBook.SaveAs("financial_report_encrypted.xlsx");

Console.WriteLine("Workbook encrypted successfully!");

using IronXL;
using System;

// Create a new workbook with sensitive financial data
WorkBook workBook = WorkBook.Create(ExcelFileFormat.XLSX);
WorkSheet sheet = workBook.CreateWorkSheet("FinancialData");

// Add sensitive data
sheet["A1"].Value = "Confidential Financial Report";
sheet["A3"].Value = "Revenue";
sheet["B3"].Value = 1250000;
sheet["A4"].Value = "Expenses";
sheet["B4"].Value = 750000;

// Apply formatting before encryption
sheet["B3:B4"].FormatString = "$#,##0.00";

// Encrypt the workbook with a strong password
workBook.Encrypt("F!n@nc3_S3cur3_2024");

// Save the encrypted workbook
workBook.SaveAs("financial_report_encrypted.xlsx");

Console.WriteLine("Workbook encrypted successfully!");

为什么密码只有在保存后才生效？

Excel 的加密过程会修改文件的内部结构，这需要写入磁盘。直到您调用SaveAs()，工作簿仍在内存中且未加密。这种设计允许您在提交加密版本之前进行多次修改。在使用工作簿元数据时，请记住在应用加密和保存之前设置所有属性。

我应该使用什么强度的密码？

对于商业应用，请遵循以下密码指南：

至少 12 个字符的长度
混合使用大写和小写字母
包含数字和特殊字符
避免使用字典词汇或可预测的模式
可以考虑使用 "MyExcel@Report#2024!"这样的短语。

在开发将敏感数据导出到 Excel 的应用程序时，应实施密码策略，通过编程来执行这些要求。

我可以只对特定工作表进行密码保护吗？

是的！ IronXL 支持工作簿级和工作表级保护。工作簿加密可以防止未经授权的文件访问，而工作表保护则可以防止对特定工作表进行修改。您可以将两种方法结合起来：

// Load workbook
WorkBook workBook = WorkBook.Load("multi_sheet_report.xlsx");

// Protect specific worksheets
workBook.WorkSheets["Summary"].ProtectSheet("SheetPass123");
workBook.WorkSheets["Details"].ProtectSheet("DetailPass456");

// Then encrypt the entire workbook
workBook.Encrypt("MasterPassword789!");

// Save with both protections
workBook.Save();

// Load workbook
WorkBook workBook = WorkBook.Load("multi_sheet_report.xlsx");

// Protect specific worksheets
workBook.WorkSheets["Summary"].ProtectSheet("SheetPass123");
workBook.WorkSheets["Details"].ProtectSheet("DetailPass456");

// Then encrypt the entire workbook
workBook.Encrypt("MasterPassword789!");

// Save with both protections
workBook.Save();

' Load workbook
Dim workBook As WorkBook = WorkBook.Load("multi_sheet_report.xlsx")

' Protect specific worksheets
workBook.WorkSheets("Summary").ProtectSheet("SheetPass123")
workBook.WorkSheets("Details").ProtectSheet("DetailPass456")

' Then encrypt the entire workbook
workBook.Encrypt("MasterPassword789!")

' Save with both protections
workBook.Save()

' Load workbook
Dim workBook As WorkBook = WorkBook.Load("multi_sheet_report.xlsx")

' Protect specific worksheets
workBook.WorkSheets("Summary").ProtectSheet("SheetPass123")
workBook.WorkSheets("Details").ProtectSheet("DetailPass456")

' Then encrypt the entire workbook
workBook.Encrypt("MasterPassword789!")

' Save with both protections
workBook.Save()

显示 WorkBook.Load() 和 WorkBook.Encrypt() 方法的 C# 代码，文件资源管理器显示 Excel 文件

如何从工作簿中删除密码？

要从电子表格中删除密码，只需将Password字段设置为null，如下面的代码所示：

请注意: 只有在访问工作簿后才能执行此操作。因此，必须知道原始密码。

// Remove protection for opened workbook. Original password is required.
workBook.Password = null;

// Remove protection for opened workbook. Original password is required.
workBook.Password = null;

' Remove protection for opened workbook. Original password is required.
workBook.Password = Nothing

' Remove protection for opened workbook. Original password is required.
workBook.Password = Nothing

下面是一个综合示例，展示了移除密码保护的完整工作流程：

using IronXL;

// First, open the protected workbook with the correct password
WorkBook protectedWorkBook = WorkBook.Load("encrypted_report.xlsx", "CurrentPassword123");

// Perform any necessary operations
WorkSheet sheet = protectedWorkBook.DefaultWorkSheet;
sheet["A1"].Value = "Updated after removing protection";

// Remove the password protection
protectedWorkBook.Password = null;

// Save the workbook without password protection
protectedWorkBook.SaveAs("unprotected_report.xlsx");

Console.WriteLine("Password protection removed successfully!");

using IronXL;

// First, open the protected workbook with the correct password
WorkBook protectedWorkBook = WorkBook.Load("encrypted_report.xlsx", "CurrentPassword123");

// Perform any necessary operations
WorkSheet sheet = protectedWorkBook.DefaultWorkSheet;
sheet["A1"].Value = "Updated after removing protection";

// Remove the password protection
protectedWorkBook.Password = null;

// Save the workbook without password protection
protectedWorkBook.SaveAs("unprotected_report.xlsx");

Console.WriteLine("Password protection removed successfully!");

Imports IronXL

' First, open the protected workbook with the correct password
Dim protectedWorkBook As WorkBook = WorkBook.Load("encrypted_report.xlsx", "CurrentPassword123")

' Perform any necessary operations
Dim sheet As WorkSheet = protectedWorkBook.DefaultWorkSheet
sheet("A1").Value = "Updated after removing protection"

' Remove the password protection
protectedWorkBook.Password = Nothing

' Save the workbook without password protection
protectedWorkBook.SaveAs("unprotected_report.xlsx")

Console.WriteLine("Password protection removed successfully!")

Imports IronXL

' First, open the protected workbook with the correct password
Dim protectedWorkBook As WorkBook = WorkBook.Load("encrypted_report.xlsx", "CurrentPassword123")

' Perform any necessary operations
Dim sheet As WorkSheet = protectedWorkBook.DefaultWorkSheet
sheet("A1").Value = "Updated after removing protection"

' Remove the password protection
protectedWorkBook.Password = Nothing

' Save the workbook without password protection
protectedWorkBook.SaveAs("unprotected_report.xlsx")

Console.WriteLine("Password protection removed successfully!")

何时应移除密码保护？

删除密码的常见情况包括

存档：将文件移动到安全存储中，文件级加密是多余的
系统集成：当自动化流程需要导入 Excel 数据而无需人工干预时
协作：与不需要密码访问的团队成员共享文件
迁移：将受保护的文件转换到不支持 Excel 加密的系统中使用

在从任何工作簿中移除密码保护之前，请务必确保您已获得适当授权。

IronXL提供了用一行C#代码保护和取消保护Excel workBooks 和workSheets的功能。如需了解更多高级 Excel 安全功能，请浏览我们的工作簿元数据管理和安全数据处理实践指南。

常见问题解答

如何用 C# 对 Excel 工作簿进行密码保护？

using IronXL.Excel，您可以使用 Encrypt 方法对 Excel 工作簿进行密码保护。只需加载工作簿，调用 wb.Encrypt("YourPassword")，然后保存文件即可。只需调用一个方法，就能立即保护 Excel 文件的安全，而无需 Microsoft Office Interop。

我能在不知道密码的情况下打开密码保护的 Excel 文件吗？

不，IronXL.Excel 需要正确的密码才能打开受保护的 Excel 文件。在加载受密码保护的工作簿时，必须将密码作为第二个参数提供：WorkBook.Load("file.xlsx", "password")。如果没有正确的密码，则无法访问文件。

如果我试图用错误的密码打开受保护的工作簿，会发生什么情况？

当提供的密码不正确时，IronXL 会抛出异常，而不是返回空值或空工作簿。这一安全功能可防止未经授权的访问尝试。请务必在 try-catch 块中封装受密码保护的工作簿操作，以便从容应对身份验证失败。

如何在打开 Excel 文件之前检查该文件是否受密码保护？

Excel 的文件格式不允许在不尝试打开文件的情况下检查密码保护状态。对于 IronXL，推荐的方法是先尝试加载没有密码的文件，然后捕获异常，必要时使用密码重试。

能否从 Excel 工作簿中移除密码保护？

是的，IronXL 允许您从工作簿中移除密码保护。首先，使用 WorkBook.Load("file.xlsx", "password")，用正确的密码加载受保护的工作簿，然后不加密保存，以创建不受保护的版本。

密码保护是否适用于所有 Excel 文件格式？

IronXL 支持现代 Excel 格式的密码保护，包括 .xlsx 和 .xlsm 文件。该加密功能可在不同版本的 Excel 中无缝运行，无需在系统中安装 Microsoft Office。

Is it possible to password-protect specific worksheets only?

Yes, IronXL allows you to protect specific worksheets by using the `ProtectSheet` method. This feature is useful for restricting access to certain data within a workbook while maintaining general file accessibility.

How can I remove password protection from an Excel workbook?

To remove password protection, open the workbook with the correct password, set the `Password` property to null, and save the workbook. This removes any encryption previously applied.

When is it appropriate to remove password protection from a workbook?

Removing password protection is appropriate when archiving files, integrating with systems that don't support encryption, sharing with team members who don't need secure access, or migrating to non-Excel formats.

Does IronXL support workbook-level and worksheet-level protection?

Yes, IronXL supports both workbook-level encryption and worksheet-level protection, allowing developers to implement comprehensive security measures tailored to their needs.