How can I access password protected Excel workbook in Java using POI api

by

POI should be able to open both protected xls files (using org.apache.poi.hssf.record.crypt) and protected xlsx files (using org.apache.poi.poifs.crypt). Have you tried these?

If you’re using HSSF (for a xls file), you need to set the password before opening the file. You do this with a call to:

 org.apache.poi.hssf.record.crypto.Biff8EncryptionKey.setCurrentUserPassword(password);

After that, HSSF should be able to open your file.

For XSSF, you want something like:

POIFSFileSystem fs = new POIFSFileSystem(new FileInputStream("protect.xlsx"));
EncryptionInfo info = new EncryptionInfo(fs);
Decryptor d = new Decryptor(info);
d.verifyPassword(Decryptor.DEFAULT_PASSWORD);
XSSFWorkbook wb = new XSSFWorkbook(d.getDataStream(fs));

.

Alternately, in newer versions of Apache POI, WorkbookFactory supports supplying the password when opening, so you can just do something like:

Workbook wb = WorkbookFactory.create(new File("protected.xls"), "password");

That will work for both HSSF and XSSF, picking the right one based on the format, and passing in the given password in the appropriate way for the format.

More Related Contents:

  1. How to read Excel cell having Date with Apache POI?
  2. Docx to Pdf Converter in java
  3. Apache poi Excel line chart points
  4. Removing a row from an Excel sheet with Apache POI HSSF
  5. Apache POI autoSizeColumn Resizes Incorrectly
  6. How to get an Excel Blank Cell Value in Apache POI?
  7. Trying to make simple PDF document with Apache poi
  8. apache POI java.lang.NoClassDefFoundError: org/apache/commons/compress/archivers/zip/ZipFile
  9. Reading data from xlsx with Apache POI’s SXSSFSheet
  10. Reading Specific rows of an excel [closed]
  11. What is the difference between CloseableHttpClient and HttpClient in Apache HttpClient API?
  12. How to load a large xlsx file with Apache POI?
  13. How can I read numeric strings in Excel cells as string (not numbers)?
  14. Apache POI error loading XSSFWorkbook class
  15. Apache POI – FileInputStream works, File object fails (NullPointerException)
  16. How to set axis’ labels in a Line Chart using Apache Poi
  17. how to make log4j to write to the console as well
  18. Cannot import XSSF in Apache POI
  19. Basic Excel currency format with Apache POI
  20. Alternative to deprecated getCellType
  21. Create Bar Chart in Excel with Apache POI
  22. How to insert a row between two rows in an existing excel with HSSF (Apache POI)
  23. Apache POI Streaming (SXSSF) for Reading
  24. Exception when writing to the xlsx document several times using apache poi 3.7
  25. How to Cache InputStream for Multiple Use
  26. Sending HTTP Post request with SOAP action using org.apache.http
  27. How to check if an excel cell is empty using Apache POI?
  28. Determine MS Excel file type with Apache POI
  29. Limitation while generating excel drop down list with Apache POI
  30. Make column read-only using apache poi

Leave a Comment