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

Updated: 2026年6月4日

要在C#中为工作表设置密码保护，可使用IronXL的workSheet.ProtectSheet("MyPass123")。这将对任何 Excel 工作表应用只读保护，防止未经授权的修改，同时允许用户查看内容。

快速入门：用一行代码保护工作表

使用IronXL，您可以通过调用ProtectSheet方法使任何工作表变为只读——只需一行代码即可立即保护表格。非常适合希望在 C# 中轻松实现安全防护的开发人员。

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

2复制并运行这段代码。

new IronXL.WorkBook("data.xlsx").DefaultWorkSheet.ProtectSheet("MyPass123");

new IronXL.WorkBook("data.xlsx").DefaultWorkSheet.ProtectSheet("MyPass123");

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

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

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

IronXL 教程步骤，使用 C# 库安装命令为 Excel 工作表设置密码保护

下载 C# 库，用于为工作表设置密码保护。
在已打开的工作簿中访问受密码保护的工作表
对选定的工作表应用密码保护
从选定的工作表中移除密码保护
将电子表格导出为不同的电子表格格式

开始使用 IronXL

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

IronXL 允许您访问和修改任何受保护的工作表，而无需密码。使用 IronXL 打开电子表格后，您可以修改任何工作表中的任何单元格。当您需要加载可能已被其他用户或系统应用了保护的现有电子表格时，这项功能尤其有用。

在使用受保护的工作表时，IronXL 可以无缝处理底层安全问题。您可以打开受密码保护的 Excel 工作表，并执行读取数据、更新单元格或应用公式等操作，而无需知道原始密码。这使得 IronXL.Excel 成为需要处理多个受保护文件的自动化数据处理场景的绝佳选择。

如何在工作表中应用密码保护？

为在Excel中限制对工作表的修改而允许用户查看其内容，请使用ProtectSheet方法，带有密码作为参数。例如，workSheet.ProtectSheet("IronXL")。这为所选工作表设置了基于密码的ReadOnly认证。

using IronXL;

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

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

workBook.Save();

using IronXL;

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

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

workBook.Save();

Imports IronXL

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

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

workBook.Save()

Imports IronXL

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

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

workBook.Save()

保护多个工作表

当处理包含多个工作表的复杂工作簿时，您可能需要应用不同的保护策略：

using IronXL;

// Load the workbook
WorkBook workBook = WorkBook.Load("financial-report.xlsx");

// Protect each worksheet with a different password
workBook.GetWorkSheet("Summary").ProtectSheet("SummaryPass123");
workBook.GetWorkSheet("Details").ProtectSheet("DetailsSecure456");
workBook.GetWorkSheet("Charts").ProtectSheet("ChartsProtect789");

// Save the workbook with all protections applied
workBook.SaveAs("protected-financial-report.xlsx");

using IronXL;

// Load the workbook
WorkBook workBook = WorkBook.Load("financial-report.xlsx");

// Protect each worksheet with a different password
workBook.GetWorkSheet("Summary").ProtectSheet("SummaryPass123");
workBook.GetWorkSheet("Details").ProtectSheet("DetailsSecure456");
workBook.GetWorkSheet("Charts").ProtectSheet("ChartsProtect789");

// Save the workbook with all protections applied
workBook.SaveAs("protected-financial-report.xlsx");

Imports IronXL

' Load the workbook
Dim workBook As WorkBook = WorkBook.Load("financial-report.xlsx")

' Protect each worksheet with a different password
workBook.GetWorkSheet("Summary").ProtectSheet("SummaryPass123")
workBook.GetWorkSheet("Details").ProtectSheet("DetailsSecure456")
workBook.GetWorkSheet("Charts").ProtectSheet("ChartsProtect789")

' Save the workbook with all protections applied
workBook.SaveAs("protected-financial-report.xlsx")

Imports IronXL

' Load the workbook
Dim workBook As WorkBook = WorkBook.Load("financial-report.xlsx")

' Protect each worksheet with a different password
workBook.GetWorkSheet("Summary").ProtectSheet("SummaryPass123")
workBook.GetWorkSheet("Details").ProtectSheet("DetailsSecure456")
workBook.GetWorkSheet("Charts").ProtectSheet("ChartsProtect789")

' Save the workbook with all protections applied
workBook.SaveAs("protected-financial-report.xlsx")

这种方法在管理包含不同程度敏感信息的工作表时尤其有用。您还可以将工作表保护与工作簿级密码保护相结合，以增强安全性。

当用户尝试打开受保护的工作表时会发生什么？

显示使用 IronXL 库实现 Excel 工作表保护的代码编辑器，文件资源管理器显示 .xlsx 文件

当用户尝试修改 Excel 中受保护的工作表时，系统会提示他们输入密码。如果没有正确的密码，他们只能查看内容，但不能做任何更改。在不同版本的 Excel 和其他支持 Excel 格式的电子表格应用程序中，这种保护仍然有效。

在不同场景中使用受保护的工作表

IronXL.Excel 的工作表保护功能可与 Excel 的其他操作无缝集成。您仍然可以执行读取操作、提取数据，甚至将文件转换为不同格式，同时保持保护状态。

using IronXL;

// Load a workbook and protect specific worksheets based on content
WorkBook workBook = WorkBook.Load("employee-data.xlsx");

foreach (WorkSheet sheet in workBook.WorkSheets)
{
    // Check if the sheet name contains sensitive keywords
    if (sheet.Name.Contains("Salary") || sheet.Name.Contains("Personal"))
    {
        // Apply stronger password protection to sensitive sheets
        sheet.ProtectSheet($"Secure_{sheet.Name}_2024!");
    }
    else
    {
        // Apply standard protection to other sheets
        sheet.ProtectSheet("StandardProtection");
    }
}

// Save the selectively protected workbook
workBook.SaveAs("employee-data-protected.xlsx");

using IronXL;

// Load a workbook and protect specific worksheets based on content
WorkBook workBook = WorkBook.Load("employee-data.xlsx");

foreach (WorkSheet sheet in workBook.WorkSheets)
{
    // Check if the sheet name contains sensitive keywords
    if (sheet.Name.Contains("Salary") || sheet.Name.Contains("Personal"))
    {
        // Apply stronger password protection to sensitive sheets
        sheet.ProtectSheet($"Secure_{sheet.Name}_2024!");
    }
    else
    {
        // Apply standard protection to other sheets
        sheet.ProtectSheet("StandardProtection");
    }
}

// Save the selectively protected workbook
workBook.SaveAs("employee-data-protected.xlsx");

Imports IronXL

' Load a workbook and protect specific worksheets based on content
Dim workBook As WorkBook = WorkBook.Load("employee-data.xlsx")

For Each sheet As WorkSheet In workBook.WorkSheets
    ' Check if the sheet name contains sensitive keywords
    If sheet.Name.Contains("Salary") OrElse sheet.Name.Contains("Personal") Then
        ' Apply stronger password protection to sensitive sheets
        sheet.ProtectSheet($"Secure_{sheet.Name}_2024!")
    Else
        ' Apply standard protection to other sheets
        sheet.ProtectSheet("StandardProtection")
    End If
Next

' Save the selectively protected workbook
workBook.SaveAs("employee-data-protected.xlsx")

Imports IronXL

' Load a workbook and protect specific worksheets based on content
Dim workBook As WorkBook = WorkBook.Load("employee-data.xlsx")

For Each sheet As WorkSheet In workBook.WorkSheets
    ' Check if the sheet name contains sensitive keywords
    If sheet.Name.Contains("Salary") OrElse sheet.Name.Contains("Personal") Then
        ' Apply stronger password protection to sensitive sheets
        sheet.ProtectSheet($"Secure_{sheet.Name}_2024!")
    Else
        ' Apply standard protection to other sheets
        sheet.ProtectSheet("StandardProtection")
    End If
Next

' Save the selectively protected workbook
workBook.SaveAs("employee-data-protected.xlsx")

如何从工作表中移除密码保护？

要从特定工作表中删除密码，请使用UnprotectSheet方法。只需调用workSheet.UnprotectSheet()即可移除与工作表相关的任何密码。

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

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

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

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

批量解除工作表保护

在处理多个受保护的工作表时，您可能需要同时取消所有工作表的保护。以下是一种有效的方法：

using IronXL;
using System;

// Load the protected workbook
WorkBook workBook = WorkBook.Load("multi-protected.xlsx");

// Counter for tracking operations
int unprotectedCount = 0;

// Iterate through all worksheets and remove protection
foreach (WorkSheet sheet in workBook.WorkSheets)
{
    try
    {
        sheet.UnprotectSheet();
        unprotectedCount++;
        Console.WriteLine($"Unprotected: {sheet.Name}");
    }
    catch (Exception ex)
    {
        Console.WriteLine($"Failed to unprotect {sheet.Name}: {ex.Message}");
    }
}

Console.WriteLine($"Successfully unprotected {unprotectedCount} worksheets");

// Save the unprotected workbook
workBook.SaveAs("multi-unprotected.xlsx");

using IronXL;
using System;

// Load the protected workbook
WorkBook workBook = WorkBook.Load("multi-protected.xlsx");

// Counter for tracking operations
int unprotectedCount = 0;

// Iterate through all worksheets and remove protection
foreach (WorkSheet sheet in workBook.WorkSheets)
{
    try
    {
        sheet.UnprotectSheet();
        unprotectedCount++;
        Console.WriteLine($"Unprotected: {sheet.Name}");
    }
    catch (Exception ex)
    {
        Console.WriteLine($"Failed to unprotect {sheet.Name}: {ex.Message}");
    }
}

Console.WriteLine($"Successfully unprotected {unprotectedCount} worksheets");

// Save the unprotected workbook
workBook.SaveAs("multi-unprotected.xlsx");

Imports IronXL
Imports System

' Load the protected workbook
Dim workBook As WorkBook = WorkBook.Load("multi-protected.xlsx")

' Counter for tracking operations
Dim unprotectedCount As Integer = 0

' Iterate through all worksheets and remove protection
For Each sheet As WorkSheet In workBook.WorkSheets
    Try
        sheet.UnprotectSheet()
        unprotectedCount += 1
        Console.WriteLine($"Unprotected: {sheet.Name}")
    Catch ex As Exception
        Console.WriteLine($"Failed to unprotect {sheet.Name}: {ex.Message}")
    End Try
Next

Console.WriteLine($"Successfully unprotected {unprotectedCount} worksheets")

' Save the unprotected workbook
workBook.SaveAs("multi-unprotected.xlsx")

Imports IronXL
Imports System

' Load the protected workbook
Dim workBook As WorkBook = WorkBook.Load("multi-protected.xlsx")

' Counter for tracking operations
Dim unprotectedCount As Integer = 0

' Iterate through all worksheets and remove protection
For Each sheet As WorkSheet In workBook.WorkSheets
    Try
        sheet.UnprotectSheet()
        unprotectedCount += 1
        Console.WriteLine($"Unprotected: {sheet.Name}")
    Catch ex As Exception
        Console.WriteLine($"Failed to unprotect {sheet.Name}: {ex.Message}")
    End Try
Next

Console.WriteLine($"Successfully unprotected {unprotectedCount} worksheets")

' Save the unprotected workbook
workBook.SaveAs("multi-unprotected.xlsx")

工作表保护的最佳实践

在您的 C# 应用程序中实施工作表保护时，请考虑这些建议：

1.使用强密码：生成结合字母、数字和特殊字符的复杂密码。考虑使用密码管理器或安全存储器来管理多个工作表密码。

2.文档保护状态：维护一份日志，记录哪些工作表受到保护及其原因。这有助于维护和故障排除。

3.与许可证管理相结合：在分发受保护的 Excel 文件时，请确保您已针对部署场景正确配置了 IronXL 许可证。

4.测试保护方案：在部署受保护的工作表之前，请使用各种 Excel 版本对其进行测试，以确保兼容性。

5.考虑性能：虽然保护不会对性能产生重大影响，但在大型工作簿中处理许多受保护的工作表可能需要优化策略。

高级保护方案

IronXL 的工作表保护可以集成到更复杂的工作流程中。例如，您可以创建带有预配置保护设置的新电子表格：

using IronXL;
using System;

// Create a new workbook with protected templates
WorkBook workBook = WorkBook.Create();

// Add and configure protected worksheets
WorkSheet budgetSheet = workBook.CreateWorkSheet("Budget2024");
budgetSheet["A1"].Value = "Annual Budget";
budgetSheet["A2"].Value = "Department";
budgetSheet["B2"].Value = "Allocated Amount";
// Add more data...
budgetSheet.ProtectSheet("BudgetProtect2024");

WorkSheet forecastSheet = workBook.CreateWorkSheet("Forecast");
forecastSheet["A1"].Value = "Revenue Forecast";
// Add forecast data...
forecastSheet.ProtectSheet("ForecastSecure123");

// Save the protected workbook
workBook.SaveAs("protected-templates.xlsx");

using IronXL;
using System;

// Create a new workbook with protected templates
WorkBook workBook = WorkBook.Create();

// Add and configure protected worksheets
WorkSheet budgetSheet = workBook.CreateWorkSheet("Budget2024");
budgetSheet["A1"].Value = "Annual Budget";
budgetSheet["A2"].Value = "Department";
budgetSheet["B2"].Value = "Allocated Amount";
// Add more data...
budgetSheet.ProtectSheet("BudgetProtect2024");

WorkSheet forecastSheet = workBook.CreateWorkSheet("Forecast");
forecastSheet["A1"].Value = "Revenue Forecast";
// Add forecast data...
forecastSheet.ProtectSheet("ForecastSecure123");

// Save the protected workbook
workBook.SaveAs("protected-templates.xlsx");

IRON VB CONVERTER ERROR developers@ironsoftware.com

IRON VB CONVERTER ERROR developers@ironsoftware.com

有关全面的 Excel 文件操作功能，请浏览完整的 IronXL 文档，或查看有关读取 Excel 文件的教程，以扩展您的 Excel 自动化工具包。

IronXL 允许您使用一行 C# 代码来保护和取消保护任何 Excel工作簿和工作表。

常见问题解答

如何在 C# 中对 Excel 工作表进行密码保护？

您可以使用 IronXL.Excel 的 ProtectSheet 方法在 C# 中对 Excel 工作表进行密码保护。只需在任何工作表对象上调用 workSheet.ProtectSheet("YourPassword")。这将应用只读保护，防止未经授权的修改，同时允许用户查看内容。

我能否在不知道密码的情况下访问和修改受密码保护的工作表？

是的，IronXL 允许您访问和修改任何受保护的工作表，而无需原始密码。一旦用 IronXL 打开电子表格，就可以修改任何工作表中的任何单元格，因此非常适合需要处理多个受保护文件的自动化数据处理场景。

ProtectSheet 方法适用于哪种类型的保护？

IronXL 中的 ProtectSheet 方法会对所选工作表应用只读身份验证。这意味着用户可以查看内容，但在 Excel 中打开文件时，如果没有输入正确的密码，则无法进行修改。

能否使用不同的密码保护多个工作表？

是的，IronXL 允许您使用唯一密码保护多个工作表。您可以遍历工作簿中的工作表，并使用 ProtectSheet 方法对每个工作表应用不同的密码，例如 workBook.GetWorkSheet("Summary").ProtectSheet("SummaryPass123")。

用代码保护 Excel 工作表的最简单方法是什么？

最简单的方法是使用 IronXL 的单行代码方法：new IronXL.WorkBook("data.xlsx").DefaultWorkSheet.ProtectSheet("MyPass123")。这样就能立即为默认工作表提供密码保护。

密码保护是否会影响将工作表导出为不同格式的能力？

不，IronXL 中的密码保护不会阻止您将工作表导出为不同的电子表格格式。应用密码保护后，您仍可将受保护的工作表保存并导出为各种 Excel 格式。

Can I integrate worksheet protection in complex Excel workflows?

Yes, IronXL's worksheet protection feature can be integrated into complex workflows, enabling you to create new spreadsheets with pre-configured protection settings, manage sensitive data, and automate data processing.

What happens if a user tries to modify a protected worksheet without the password?

If a user tries to modify a protected worksheet, Excel will prompt them to enter the correct password. Without it, they can only view the content but cannot make changes.

Does worksheet protection affect performance in IronXL?

While protection does not significantly impact performance, working with many protected worksheets in large workbooks may require optimization strategies to maintain efficiency.

How can I ensure compatibility of protected worksheets across different Excel versions?

Testing protected worksheets with various Excel versions before deployment ensures compatibility and helps identify any potential issues with different spreadsheet applications that support the Excel format.