poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Danny Mui <da...@muibros.com>
Subject Re: Reading JSP generated Excel file using HSSF
Date Wed, 05 Jan 2005 19:36:42 GMT
HSSF only knows how to interpret the binary format and not the HTML 
format.  What you have there sounds like Excel's HTML format (Save As 
HTML rather than Save As Excel 95).


Vishal wrote:

>I generate excel reports using JSP that makes HTML table and then
>setting mimetype. The excel file is saved on the server to be later
>served up on request, which works fine.Now, I would like to read this excel 
>file into an HSSFWorkbook so I can make simple changes like freeze pane before
>sending to user. The problem is that HSSF does not seem to accept this
>as an Excel file even though it is one. The exception is
>an invalid header signature. 
>I noticed that when i bring the file up in excel seperately, it is thought
>of as an excel file but the default is to save as an html. even though
>the report is right there in a excel worksheet(converted from html table).
>Is there a way to read this file into HSSF since it is a valid excel file
>in the excel world??
>
>thanks
>Vishal
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: poi-user-help@jakarta.apache.org
>  
>


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


Mime
View raw message