Detect if Worksheet is Password Protected

Contents
[ ]

Aspose.Cells for .NET 8.7.0 has exposed the Protection.IsProtectedWithPassword property to detect if a worksheet is password protected or not. Boolean type Protection.IsProtectedWithPassword property returns true if Worksheet is password-protected and false if not.

// 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);
// Create an instance of Workbook and load a spreadsheet
var book = new Workbook(dataDir + "sample.xlsx");
// Access the protected Worksheet
var sheet = book.Worksheets[0];
// Check if Worksheet is password protected
if (sheet.Protection.IsProtectedWithPassword)
{
Console.WriteLine("Worksheet is password protected");
}
else
{
Console.WriteLine("Worksheet is not password protected");
}