import com.spire.xls.*;

public class ProtectWb {
    public static void main(String[] args) {
        //加載測(cè)試文檔
        Workbook wb = new Workbook();
        wb.loadFromFile("sample.xlsx");

        //使用密碼加密工作簿
        wb.protect("123456");

        //保存文檔
        wb.saveToFile("ProtectWorkbook.xlsx", ExcelVersion.Version2010);
        wb.dispose();
    }
}

import com.spire.xls.*;

public class UnprotectWb {
    public static void main(String[] args) {
        //加載文檔
        Workbook wb = new Workbook();
        wb.setOpenPassword("123456");//源文檔密碼
        wb.loadFromFile("ProtectWorkbook.xlsx");

        //解除密碼保護(hù)
        wb.unProtect();

        //保存文檔
        wb.saveToFile("UnprotectWb.xlsx");
        wb.dispose();
    }
}

import com.spire.xls.*;

import java.util.EnumSet;

public class ProtectSheet {
    public static void main(String[] args) {
        //加載測(cè)試文檔
        Workbook wb = new Workbook();
        wb.loadFromFile("sample.xlsx");

        //獲取第一個(gè)工作表
        Worksheet sheet = wb.getWorksheets().get(0);

        //使用密碼加密保護(hù)
        sheet.protect("654321", EnumSet.of(SheetProtectionType.All));

        //保存文檔
        wb.saveToFile("ProtectWorksheet.xlsx", ExcelVersion.Version2010);
        wb.dispose();
    }
}

import com.spire.xls.*;

import java.util.EnumSet;

public class ProtectRange {
    public static void main(String[] args) {
        //加載測(cè)試文檔
        Workbook wb = new Workbook();
        wb.loadFromFile("sample.xlsx");

        //獲取第一個(gè)工作表
        Worksheet sheet = wb.getWorksheets().get(0);

        //密碼加密工作表
        sheet.protect("123654", EnumSet.of(SheetProtectionType.All));
        //指定可編輯的區(qū)域
        sheet.addAllowEditRange("AllowEdit",sheet.getCellRange(3,1,11,8));

        //保存文檔
        wb.saveToFile("ProtectRange.xlsx", ExcelVersion.Version2010);
        wb.dispose();
    }
}

import com.spire.xls.*;

import java.util.EnumSet;

public class ProtectAndHideFormula {
    public static void main(String[] args) {
        //加載文檔
        Workbook  wb = new Workbook();
        wb.loadFromFile("sample.xlsx");

        //獲取工作表
        Worksheet sheet = wb.getWorksheets().get(0);

        //設(shè)置加密
        sheet.protect("123", EnumSet.of(SheetProtectionType.All));
        //隱藏公式
        sheet.getAllocatedRange().isFormulaHidden(true);

        //保存文檔
        wb.saveToFile("HideFormula.xlsx",FileFormat.Version2010);
        wb.dispose();
    }
}

import com.spire.xls.*;

public class UnprotectSheet {
    public static void main(String[] args) {
        //加載文檔
        Workbook  wb = new Workbook();
        wb.loadFromFile("ProtectWorksheet.xlsx");

        //獲取工作表
        Worksheet sheet = wb.getWorksheets().get(0);

        //解除密碼保護(hù)（需輸入源文檔密碼）
        sheet.unprotect("654321");

        //保存文檔
        wb.saveToFile("UnprotectSheet.xlsx",ExcelVersion.Version2010);
        wb.dispose();
    }
}