Workbook protection

The following example shows you how to protect a worksheet with a password and lock the workbook structure to prevent adding or removing sheets.

import com.independentsoft.office.spreadsheet.Cell;
import com.independentsoft.office.spreadsheet.SheetProtection;
import com.independentsoft.office.spreadsheet.Workbook;
import com.independentsoft.office.spreadsheet.Worksheet;

public class Example {

    public static void main(String[] args)
    {
        try
        {
            Workbook book = new Workbook();

            Worksheet sheet = new Worksheet();
            sheet.setName("Protected Sheet");
            sheet.set("A1", new Cell("This worksheet is protected."));

            SheetProtection sheetProtection = new SheetProtection();
            sheetProtection.setSheetLocked(true);
            sheetProtection.setObjectsLocked(true);
            sheetProtection.setScenariosLocked(true);
            sheetProtection.setPassword("sheetpass");
            sheet.setSheetProtection(sheetProtection);

            book.getSheets().add(sheet);

            book.setLockStructure(true);
            book.setWorkbookPassword("workbookpass");

            book.save("c:\\test\\output.xlsx", true);
            System.out.println("Workbook saved with protection.");
        }
        catch (Exception e)
        {
            System.out.println(e.getMessage());
            e.printStackTrace();
        }
    }
}

IndependentsoftProfessional software libraries for developers

JSpreadsheet > Tutorial > Workbook protection

Need help? Ask our developers: