poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sateesh K Kolusu" <sateesh.kol...@in.ibm.com>
Subject excel processing differences
Date Thu, 15 Jun 2017 12:03:43 GMT
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 


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message