Excel workbook protection
GemBox.Spreadsheet for Java has been retired
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 shows how you can protect a workbook.

import com.gembox.spreadsheet.*;
class Program {
public static void main(String[] args) throws java.io.IOException {
// If using the 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");
}
}
See also
Next steps
Published: February 25, 2019 | Modified: March 9, 2023 | Author: Marek Turis