使用JAVA给excel添加密码

1、maven的pom文件中添加依赖仓以及具体依赖（注意修改pom文件后需要刷新maven）：

  <repositories>
    <repository>
      <id>com.e-iceblue</id>
      <name>e-iceblue</name>
      <url>https://repo.e-iceblue.cn/repository/maven-public/</url>
    </repository>
  </repositories>

  <dependencies>
    <dependency>
      <groupId>e-iceblue</groupId>
      <artifactId>spire.xls.free</artifactId>
      <version>3.9.1</version>
    </dependency>

    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>3.8.1</version>
      <scope>test</scope>
    </dependency>

    <dependency>
      <groupId>org.apache.poi</groupId>
      <artifactId>poi</artifactId>
      <version>5.0.0</version>
    </dependency>

    <dependency>
      <groupId>org.apache.poi</groupId>
      <artifactId>poi-ooxml</artifactId>
      <version>5.0.0</version>
    </dependency>

    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>RELEASE</version>
      <scope>compile</scope>
    </dependency>

  </dependencies>

2、加密以及解密的代码如下：

    @Test
    public void lockFile() {
        //加载测试文档
        Workbook wb = new Workbook();
        wb.loadFromFile("D:\\developer\\test\\testDemo2.xlsx");
        //使用密码加密工作簿
        wb.protect("123456");
        //保存文档
        wb.saveToFile("ProtectWorkbook.xlsx", ExcelVersion.Version2010);
        wb.dispose();
    }

    @Test
    public void unLockFile(){
        //加载文档
        Workbook wb = new Workbook();
        wb.setOpenPassword("123456");//源文档密码
        wb.loadFromFile("ProtectWorkbook.xlsx");
        //解除密码保护
        wb.unProtect();
        //保存文档
        wb.saveToFile("UnprotectWb.xlsx");
        wb.dispose();
    }