怎么用JAVA给生成的EXCEL加密

发布网友发布时间：2022-04-21 22:53

共2个回答

热心网友时间：2023-04-28 15:01

Biff8EncryptionKey.setCurrentUserPassword("pass");
NPOIFSFileSystem fs = new NPOIFSFileSystem(new File("file.xls"), true);
HSSFWorkbook hwb = new HSSFWorkbook(fs.getRoot(), true);
Biff8EncryptionKey.setCurrentUserPassword(null);

// RC4 CryptoApi support ppt - decryption
Biff8EncryptionKey.setCurrentUserPassword("pass");
NPOIFSFileSystem fs = new NPOIFSFileSystem(new File("file.ppt"), true);
HSLFSlideShow hss = new HSLFSlideShow(fs);
...
// Option 1: remove password
Biff8EncryptionKey.setCurrentUserPassword(null);
OutputStream os = new FileOutputStream("decrypted.ppt");
hss.write(os);
os.close();
...
// Option 2: change encryption settings (experimental)
// need to cache data (i.e. read all data) before changing the key size
PictureData picsExpected[] = hss.getPictures();
hss.getDocumentSummaryInformation();
EncryptionInfo ei = hss.getDocumentEncryptionAtom().getEncryptionInfo();
((CryptoAPIEncryptionHeader)ei.getHeader()).setKeySize(0x78);
OutputStream os = new FileOutputStream("file_120bit.ppt");
hss.write(os);
os.close();

热心网友时间：2023-04-28 15:02

添加spire.xls.jar为依赖，参考下面的代码：

import com.spire.xls.*;

public class EncryptWorkbook {

public static void main(String[] args) {

//加载示例文档

Workbook workbook = new Workbook();

workbook.loadFromFile("Sample.xlsx");

//使用密码加密保护

workbook.protect("eiceblue");

//保存文档

workbook.saveToFile("output/EncryptWorkbook.xlsx", ExcelVersion.Version2010);

}