Excel workbook protection

Workbook protection allows you to protect structure of a workbook against modifications, such as deleting or renaming of sheets.

Note that workbook protection is supported only for XLSX file format.

The following example demonstrates how to protect a workbook.

Screenshot of Excel workbook protected with GemBox.Spreadsheet for Java
Excel workbook protected with GemBox.Spreadsheet for Java
import com.gembox.spreadsheet.*;

class Program {

    public static void main(String[] args) throws java.io.IOException {
        // If using Professional version, put your serial key below.
        SpreadsheetInfo.setLicense("FREE-LIMITED-KEY");

        ExcelFile workbook = new ExcelFile();
        ExcelWorksheet worksheet = workbook.addWorksheet("Workbook Protection");

        // ProtectionSettings class is supported only for XLSX file format.
        WorkbookProtection protectionSettings = workbook.getProtectionSettings();
        protectionSettings.setProtectStructure(true);

        worksheet.getCell(0, 0).setValue("Workbook password is 123 (only supported for XLSX file format).");
        protectionSettings.setPassword("123");

        workbook.save("Workbook Protection.xlsx");
    }
}
-

Check next example or download examples from GitHub.