You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2008/09/26 21:26:06 UTC

DO NOT REPLY [Bug 45901] New: Error Opening Excel .xls file in mhtml format 

https://issues.apache.org/bugzilla/show_bug.cgi?id=45901

           Summary: Error Opening Excel .xls file in mhtml format <Rel. POI
                    3.1>
           Product: POI
           Version: 3.1
          Platform: PC
        OS/Version: Windows XP
            Status: NEW
          Severity: critical
          Priority: P2
         Component: POIFS
        AssignedTo: dev@poi.apache.org
        ReportedBy: madan.kawle@gmail.com


Hello,

I am generating the Cognos Reports through Java using Cognos API. While
generating the reports we set the outputformat to XLWA (Microsoft Excel Web
Archive (XLWA) format). The reports generated files have .xls extension.

When I try to read this file it gives me the following error:

------------------------------------------------------------------
java.io.IOException: Invalid header signature; read 8243089445407770957,
expected -2226271756974174256
        at
org.apache.poi.poifs.storage.HeaderBlockReader.<init>(HeaderBlockReader.java:112)
        at
org.apache.poi.poifs.filesystem.POIFSFileSystem.<init>(POIFSFileSystem.java:151)
-------------------------------------------------------------------

If I open and save one of the report files in XLS format. The POI is able to
read it correctly. Looks like it is unable to recognize the format. But since
these reports are generated in batch mode and in huge number it is practically
not possible to open and save all these reports in XLS format. Also, if I try
to use SaveAs of MS-Excel, it show the SaveAs file Type to be mthml.

I will appreciate if you could give me some pointers on this.

Thanks in advance!


-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

DO NOT REPLY [Bug 45901] Error Opening Excel .xls file in mhtml format

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=45901


Nick Burch <ni...@torchbox.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|                            |INVALID




--- Comment #1 from Nick Burch <ni...@torchbox.com>  2008-09-26 13:01:41 PST ---
IIRC, mhtml = html in a specific format

The error tells you that the file isn't in ole2 format, so isn't a "real" excel
file

If it's html, just process it with a html parser


-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org