poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dominik Stadler <dominik.stad...@gmx.at>
Subject Re: excel processing differences
Date Thu, 15 Jun 2017 13:27:19 GMT
Can you share the relevant code in SSFile?

Dominik

On Jun 15, 2017 14:03, "Sateesh K Kolusu" <sateesh.kolusu@in.ibm.com> wrote:

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