如何在 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");

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

Dim 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!");

Imports IronXL
Imports System

' Create a new workbook with sensitive financial data
Dim workBook As WorkBook = WorkBook.Create(ExcelFileFormat.XLSX)
Dim sheet As WorkSheet = 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!")

Imports IronXL
Imports System

' Create a new workbook with sensitive financial data
Dim workBook As WorkBook = WorkBook.Create(ExcelFileFormat.XLSX)
Dim sheet As WorkSheet = 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.

Curtis Chau

技术作家

立即与工程团队聊天

Curtis Chau 拥有卡尔顿大学的计算机科学学士学位，专注于前端开发，精通 Node.js、TypeScript、JavaScript 和 React。他热衷于打造直观且美观的用户界面，喜欢使用现代框架并创建结构良好、视觉吸引力强的手册。