Test code3

EncryptDecryptTest3.java (text/plain), 4.10 KB, created by Tom Xin on 2023-01-20 15:59:11 UTC

(hide)

Description: Test code3

Filename:

MIME Type:

Creator: Tom Xin

Created: 2023-01-20 15:59:11 UTC

Size: 4.10 KB

patch

obsolete

>package org.dhatim.fastexcel; > >import org.apache.commons.compress.archivers.zip.ZipArchiveEntry; >import org.apache.commons.compress.archivers.zip.ZipFile; >import org.apache.poi.openxml4j.exceptions.InvalidFormatException; >import org.apache.poi.openxml4j.opc.OPCPackage; >import org.apache.poi.poifs.crypt.Decryptor; >import org.apache.poi.poifs.crypt.EncryptionInfo; >import org.apache.poi.poifs.crypt.EncryptionMode; >import org.apache.poi.poifs.crypt.Encryptor; >import org.apache.poi.poifs.filesystem.POIFSFileSystem; >import org.apache.poi.util.IOUtils; >import org.apache.poi.xssf.usermodel.XSSFCell; >import org.apache.poi.xssf.usermodel.XSSFRow; >import org.apache.poi.xssf.usermodel.XSSFSheet; >import org.apache.poi.xssf.usermodel.XSSFWorkbook; >import org.junit.jupiter.api.Test; > >import java.io.*; >import java.security.GeneralSecurityException; > >public class EncryptDecryptTest { > > static final String secretKey = "foobaa"; > > @Test > void protectTest3() throws IOException, InvalidFormatException, GeneralSecurityException { > > final String temp_excel_poi = "D://temp_excel_poi.xlsx"; > final String temp_excel_poi_encrypt = "D://temp_excel_poi_encrypt.xlsx"; > final String temp_excel_poi_decrypt = "D://temp_excel_poi_decrypt.xlsx"; > > /* create new excel by poi */ > try (XSSFWorkbook workbook = new XSSFWorkbook(); FileOutputStream foss = new FileOutputStream(temp_excel_poi)) { > XSSFSheet sheet = workbook.createSheet(); > XSSFRow row = sheet.createRow(0); > XSSFCell cell = row.createCell(0); > cell.setCellValue("Hello Apache POI"); > workbook.write(foss); > } > > /* encrypt excel by poi */ > try (POIFSFileSystem fs = new POIFSFileSystem()) { > EncryptionInfo info = new EncryptionInfo(EncryptionMode.agile); > // EncryptionInfo info = new EncryptionInfo(EncryptionMode.agile, CipherAlgorithm.aes192, HashAlgorithm.sha384, -1, -1, null); > Encryptor enc = info.getEncryptor(); > enc.confirmPassword(secretKey); > // Read in an existing OOXML file and write to encrypted output stream > // don't forget to close the output stream otherwise the padding bytes aren't added > try (OPCPackage opc = OPCPackage.open(temp_excel_poi); OutputStream os = enc.getDataStream(fs)) { > opc.save(os); > } > // Write out the encrypted version > try (FileOutputStream fos = new FileOutputStream(temp_excel_poi_encrypt)) { > fs.writeFilesystem(fos); > } > } > /* decrypt excel by poi */ > try (POIFSFileSystem fileSystem = new POIFSFileSystem(new File(temp_excel_poi_encrypt))) { > EncryptionInfo info = new EncryptionInfo(fileSystem); > Decryptor d = Decryptor.getInstance(info); > if (!d.verifyPassword(secretKey)) { > throw new RuntimeException("Unable to process: document is encrypted"); > } > // parse dataStream > try (InputStream dataStream = d.getDataStream(fileSystem); FileOutputStream fos = new FileOutputStream(temp_excel_poi_decrypt)) { > IOUtils.copy(dataStream, fos); > } > } catch (GeneralSecurityException ex) { > throw new RuntimeException("Unable to process encrypted document", ex); > } > > readByCommonsCompress(temp_excel_poi); > > readByCommonsCompress(temp_excel_poi_decrypt); > > } > > private static void readByCommonsCompress(String temp_excel_poi) throws IOException { > /* read by commons-compress*/ > try (ZipFile zipFile = new ZipFile(new File(temp_excel_poi))) { > ZipArchiveEntry entry = zipFile.getEntry("xl/worksheets/sheet1.xml"); > InputStream inputStream = zipFile.getInputStream(entry); > BufferedReader bufferedReader = new BufferedReader(new InputStreamReader(inputStream), 1); > String line; > while ((line = bufferedReader.readLine()) != null) { > System.out.println(line); > } > } > } >} View Attachment As Raw

This is ASF Bugzilla: the Apache Software Foundation bug system. In case of problems with the functioning of ASF Bugzilla, please contact bugzilla-admin@apache.org. Please Note: this e-mail address is only for reporting problems with ASF Bugzilla. Mail about any other subject will be silently ignored.

• • Home
  • | New
  • | Browse
  • | Search
  • |
    [?]
  • | Reports
  • | Help
  • | New Account
  • | Log In
    Remember [x]
  • | Forgot Password
    Login: [x]