Hello all -
Good day. We have a password XLS sheet with macros and when we use MS
Office 2010 to save the file as "Excel97-2003" format, we are able to read
the file and process the file.
If we use MS Office 2013 (and higher. I used 2016) and save the file as
"Excel97-2003" format, then we are not able to read the file. It gives
error
java.io.FileNotFoundException: no such entry: "EncryptionInfo", had:
[CompObj, _VBA_PROJECT_CUR, DocumentSummaryInformation,
SummaryInformation, Workbook]
at
org.apache.poi.poifs.filesystem.DirectoryNode.getEntry(DirectoryNode.java:399)
at
org.apache.poi.poifs.filesystem.DirectoryNode.createDocumentInputStream(DirectoryNode.java:188)
at
org.apache.poi.poifs.crypt.EncryptionInfo.<init>(EncryptionInfo.java:94)
at
org.apache.poi.poifs.crypt.EncryptionInfo.<init>(EncryptionInfo.java:76)
at com.ibm.is.cc.unstructured.poi.SSFile.readFile(SSFile.java:169)
at
com.ibm.is.cc.unstructured.api.ExcelFile.readFile(ExcelFile.java:143)
I am using POI 3.14
---
Thanks
Sateesh
