使用Aspose.Cells检查修改密码
Contents
[
Hide
]
有时,您需要通过编程方式检查给定的密码是否与修改密码匹配。Aspose.Cells提供WorkbookSettings.WriteProtection.ValidatePassword()方法,您可以使用该方法检查给定的修改密码是否正确。
在Microsoft Excel中检查修改密码
您可以在创建Microsoft Excel工作簿时指定打开密码和修改密码。请参阅此截图,显示Microsoft Excel提供的界面以指定这些密码。
![]() |
---|
使用Aspose.Cells检查修改密码
以下示例代码加载了源 Excel 文件。它具有打开密码为1234和修改密码为5678。该代码首先检查是否567为正确的修改密码,并返回false,然后检查是否5678为修改密码,并返回true。
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
// The path to the documents directory. | |
string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); | |
// Specify password to open inside the load options | |
LoadOptions opts = new LoadOptions(); | |
opts.Password = "1234"; | |
// Open the source Excel file with load options | |
Workbook workbook = new Workbook(dataDir + "sampleBook.xlsx", opts); | |
// Check if 567 is Password to modify | |
bool ret = workbook.Settings.WriteProtection.ValidatePassword("567"); | |
Console.WriteLine("Is 567 correct Password to modify: " + ret); | |
// Check if 5679 is Password to modify | |
ret = workbook.Settings.WriteProtection.ValidatePassword("5678"); | |
Console.WriteLine("Is 5678 correct Password to modify: " + ret); |
控制台输出
这是加载了源 Excel 文件后的上述示例代码的控制台输出。
Is 567 correct Password to modify: False
Is 5678 correct Password to modify: True