Detect if Worksheet is Password Protected

Detect if Worksheet is Password Protected

Aspose.Cells for Java 8.7.0 has exposed the Protection.isProtectedWithPassword property to detect if a worksheet is password protected or not. Boolean type Protection.isProtectedWithPassword field 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-Java
// The path to the documents directory.
String dataDir = Utils.getDataDir(DetectWorksheetisPasswordProtected.class);
// Create an instance of Workbook and load a spreadsheet
Workbook book = new Workbook(dataDir + "sample.xlsx");
// Access the protected Worksheet
Worksheet sheet = book.getWorksheets().get(0);
// Check if Worksheet is password protected
if (sheet.getProtection().isProtectedWithPassword()) {
System.out.println("Worksheet is password protected");
}