JAVA POI 对excel加密后无法打开的解决办法

最新推荐文章于 2024-02-23 11:29:47 发布

qq_30292541

最新推荐文章于 2024-02-23 11:29:47 发布

阅读量1.4k

点赞数 4

文章标签： poi java

原文链接：https://www.it610.com/article/1304556202281177088.htm

版权

网上给的参考代码

POIFSFileSystem fs = new POIFSFileSystem();
  EncryptionInfo info = new EncryptionInfo(EncryptionMode.agile);

  Encryptor enc = info.getEncryptor();
  enc.confirmPassword("foobaa");

   OPCPackage opc = OPCPackage.open(new File("D:/test/encrty.xlsx"), PackageAccess.READ_WRITE);
  //OPCPackage opc = OPCPackage. .create(FileOutputStream);
  OutputStream os = enc.getDataStream(fs);
 
  opc.save(os);
  opc.close();

  FileOutputStream fos = new FileOutputStream("D:/test/encrty.xlsx");
  fs.writeFilesystem(fos);
  fos.close();

是不对的，正确写法：

	POIFSFileSystem fs = new POIFSFileSystem();
    EncryptionInfo info = new EncryptionInfo(EncryptionMode.agile);
    Encryptor enc = info.getEncryptor();
    enc.confirmPassword("admin");
    try {
        OutputStream os = enc.getDataStream(fs);
        workbook.write(os);
        workbook.close();
        os.close();
        //写入response流
        fs.writeFilesystem(response.getOutputStream());
    } catch (Exception e) {
        e.printStackTrace();
    }

感谢 https://www.it610.com/article/1304556202281177088.htm