poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andrew C. Oliver" <acoli...@apache.org>
Subject Re: Excel File Download using JSP
Date Tue, 22 Jul 2003 02:45:44 GMT
I think we should move the FAQ all onto the wiki....Then you wouldn't have
to plan.

On 7/21/03 4:38 PM, "Danny Mui" <danny@muibros.com> wrote:

> Oh, I also plan to add this to the FAQ sometime soon.
> 
> If you hit "open" it will fail in IE.  Put a, response.reset() somewhere
> before you write it out and that will be fixed.
  
> Andrew Riggin wrote:
> 
>> Dan,
>> 
>> Your code worked!!  Thank you.
>> 
>> Andrew
>> 
>> 
>> 
>>> From: Danny Mui <danny@muibros.com>
>>> Reply-To: "POI Users List" <poi-user@jakarta.apache.org>
>>> To: POI Users List <poi-user@jakarta.apache.org>
>>> Subject: Re: Excel File Download using JSP
>>> Date: Mon, 21 Jul 2003 15:14:29 -0400
>>> 
>>> I don't see where the output is written to the servlet stream so
>>> excel is not receiving the file poi created.
>>> 
>>> wb.write(response.getOutputStream());
>>> 
>>> would probably give you what you're looking for.
>>> 
>>> 
>>> 
>>> Andrew Riggin wrote:
>>> 
>>>> I searched through the entire mailing list looking for an answer to
>>>> my question but couldn't find one.
>>>> Here is the situation:  I have one program that makes excel reports
>>>> from an Access database using POI.  This program saves the reports
>>>> to a Tomcat server on my system.  I have a JSP called DisplayReports
>>>> which uses a JavaBean to find the files on the server and post links
>>>> for each file to another JSP called DownloadFile.  When i link is
>>>> clicked on DisplayReports.jsp, it is suppose to run Downloads.jsp,
>>>> the Open/Save dialog box opens and then it down loads to the user
>>>> specified directory.  The relevant portion of the code in
>>>> Download.jsp looks like this:
>>>> 
>>>> String filepath = dbBean.getDataPath();
>>>>  response.setContentType("APPLICATION/OCTET-STREAM");
>>>>  response.setHeader("Content-Disposition",
>>>>  "attachment; filename=\"" + filename + "\"");
>>>> 
>>>> POIFSFileSystem fs = new POIFSFileSystem(new
>>>> FileInputStream(filepath + filename));
>>>>    HSSFWorkbook wb = new HSSFWorkbook(fs);
>>>>    FileOutputStream fileOut = new FileOutputStream(filename);
>>>> 
>>>> wb.write(fileOut);
>>>>    fileOut.close();
>>>> 
>>>> It downloads the excel workbook with the correct name but their is
>>>> no data and no sheets.  What do I need to add?
>>>> 
>>>> Thanks,
>>>> 
>>>> Andrew
>>>> 
>>>> _________________________________________________________________
>>>> STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
>>>> http://join.msn.com/?page=features/junkmail
>>>> 
>>>> 
>>>> ---------------------------------------------------------------------
>>>> 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
>>> 
>> 
>> _________________________________________________________________
>> Help STOP SPAM with the new MSN 8 and get 2 months FREE*
>> http://join.msn.com/?page=features/junkmail
>> 
>> 
>> ---------------------------------------------------------------------
>> 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
> 

-- 
Andrew C. Oliver
http://www.superlinksoftware.com/poi.jsp
Custom enhancements and Commercial Implementation for Jakarta POI

http://jakarta.apache.org/poi
For Java and Excel, Got POI?


Mime
View raw message