Verify Password Used to Protect the Worksheet

Aspose.Cells APIs have enhanced the Protection class by introducing some useful properties and methods. One such method is the VerifyPassword which allows specifying a password as a string and verifies if the same password has been used to protect the Worksheet.

The Protection.VerifyPassword method returns true if the specified password matches the password used to protect the given worksheet and false if the specified password does not match. The following piece of code uses the Protection.VerifyPassword method in conjunction with the Protection.IsProtectedWithPassword property to detect password protection and verify the password.