使用Aspose.Cells检查修改密码

在Microsoft Excel中检查修改密码

您可以在创建Microsoft Excel工作簿时指定打开密码修改密码。请参阅此截图,显示Microsoft Excel提供的界面以指定这些密码。

todo:image_alt_text

使用Aspose.Cells检查修改密码

以下示例代码加载了源 Excel 文件。它具有打开密码为1234和修改密码为5678。该代码首先检查是否567为正确的修改密码,并返回false,然后检查是否5678为修改密码,并返回true。

// 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