You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by "Rid, Christoph" <Ch...@premium-aerotec.com> on 2012/11/14 16:14:21 UTC
reading a "shared Workbook"
Hello,
i got an exception when i try to read a password protected "shared Workbook" in Excel 2007.
Exception in thread "main" java.lang.IllegalArgumentException: The supplied POIFSFileSystem does not contain a BIFF8 'Workbook' entry. Is it really an excel file?
at org.apache.poi.hssf.usermodel.HSSFWorkbook.getWorkbookDirEntryName(HSSFWorkbook.java:229)
at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:270)
at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:250)
at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:194)
at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:329)
at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:310)
at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:64)
wb = WorkbookFactory.create(new FileInputStream(avListPath));
when I remove the sharing it works well
thanks in advance and kind regards
Christoph Rid
NOTICE: This message, together with any attachments, may contain privileged and/or confidential information. If you have received this e-mail in error or are not an intended recipient, you may not use, reproduce, disseminate or distribute it; do not open nor save any attachments, delete it immediately from your system and notify the sender promptly by e-mail that you have done so. Thank you.
RE: reading a "shared Workbook"
Posted by "Rid, Christoph" <Ch...@premium-aerotec.com>.
Hello Nick,
not an excel file by a long way??? At least I removed the password and now it works.
Anyway - thanks for the answer.
Kind regards
Chris
-----Original Message-----
From: Nick Burch [mailto:nick@apache.org]
Sent: Montag, 19. November 2012 02:33
To: user@poi.apache.org
Subject: Re: reading a "shared Workbook"
On 15/11/12 16:26, Rid, Christoph wrote:
> thanks for your reply.
> POIFSLister gives the following output:
>
> Root Entry -
> EncryptionInfo
> EncryptedPackage
> DataSpaces -
> DataSpaceMap
> DataSpaceInfo -
> StrongEncryptionDataSpace
> TransformInfo -
> StrongEncryptionTransform -
> Primary <(0x06)Primary>
> Version
That's not an excel file by a long way, which explains why POI can't read it! Sorry, you'll need to convert it to a regular excel file for processing
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org For additional commands, e-mail: user-help@poi.apache.org
NOTICE: This message, together with any attachments, may contain privileged and/or confidential information. If you have received this e-mail in error or are not an intended recipient, you may not use, reproduce, disseminate or distribute it; do not open nor save any attachments, delete it immediately from your system and notify the sender promptly by e-mail that you have done so. Thank you.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: reading a "shared Workbook"
Posted by Nick Burch <ni...@apache.org>.
On 15/11/12 16:26, Rid, Christoph wrote:
> thanks for your reply.
> POIFSLister gives the following output:
>
> Root Entry -
> EncryptionInfo
> EncryptedPackage
> DataSpaces -
> DataSpaceMap
> DataSpaceInfo -
> StrongEncryptionDataSpace
> TransformInfo -
> StrongEncryptionTransform -
> Primary <(0x06)Primary>
> Version
That's not an excel file by a long way, which explains why POI can't
read it! Sorry, you'll need to convert it to a regular excel file for
processing
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
RE: reading a "shared Workbook"
Posted by "Rid, Christoph" <Ch...@premium-aerotec.com>.
Hello Nick,
thanks for your reply.
POIFSLister gives the following output:
Root Entry -
EncryptionInfo
EncryptedPackage
DataSpaces -
DataSpaceMap
DataSpaceInfo -
StrongEncryptionDataSpace
TransformInfo -
StrongEncryptionTransform -
Primary <(0x06)Primary>
Version
Kind regards
Chris
-----Original Message-----
From: Nick Burch [mailto:nick@apache.org]
Sent: Mittwoch, 14. November 2012 17:57
To: user@poi.apache.org
Subject: Re: reading a "shared Workbook"
On 14/11/12 15:14, Rid, Christoph wrote:
> Hello,
>
> i got an exception when i try to read a password protected "shared Workbook" in Excel 2007.
>
> Exception in thread "main" java.lang.IllegalArgumentException: The supplied POIFSFileSystem does not contain a BIFF8 'Workbook' entry. Is it really an excel file?
Can you try running org.apache.poi.poifs.POIFSLister against it, and report back what entries it does contain if Workbook isn't one of them?
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org For additional commands, e-mail: user-help@poi.apache.org
NOTICE: This message, together with any attachments, may contain privileged and/or confidential information. If you have received this e-mail in error or are not an intended recipient, you may not use, reproduce, disseminate or distribute it; do not open nor save any attachments, delete it immediately from your system and notify the sender promptly by e-mail that you have done so. Thank you.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: reading a "shared Workbook"
Posted by Nick Burch <ni...@apache.org>.
On 14/11/12 15:14, Rid, Christoph wrote:
> Hello,
>
> i got an exception when i try to read a password protected "shared Workbook" in Excel 2007.
>
> Exception in thread "main" java.lang.IllegalArgumentException: The supplied POIFSFileSystem does not contain a BIFF8 'Workbook' entry. Is it really an excel file?
Can you try running org.apache.poi.poifs.POIFSLister against it, and
report back what entries it does contain if Workbook isn't one of them?
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org