This week's book giveaway is in the Programmer Certification forum. We're giving away four copies of OCP Oracle Certified Professional Java SE 11 Programmer I Study Guide: Exam 1Z0-815 and have Jeanne Boyarsky & Scott Selikoff on-line! See this thread for details.
I'm currently working on a web project to display various reports to the users of the system. One of the options they have is to get the report presented in the browser as an .xls file and here I'm using the Jakarta HSSF API to create the .xls files.
In order to present the file to the user, I thought about creating a temporary file but not wanting to overload the server with temporary .xls files, my original idea was to save it to the client machine. Perhaps with a pop-up prompting him for name and path of file or perhaps as a temporary internet file. But I'm not certain how exactly I go about that and though I've been reading up on it, I haven't found a solution yet.
Then I thought, why not simply write it to the client browser via the servlet/JSPs output stream? Well, I've tried a few different approaches but none have the desired output format (the text looks gibberish for some reason, perhaps due to content type or something not correct). As you can see in the code below, I've made a write-to-file test to ensure the content looks good enough and it does. It's just the view in the browser thats faulty..
So please, ladies and gents, be a sport and give a hand if you have a suggestion
1) You need to set those response headers before you open/write to the output stream. Otherwise the browser doesn't know it is an excel file. 2) Don't put any HTML in the page. You can ouput an excel file or an html file, but not both. The way it is written, you will wind up with some html at the bottom of your excel file.
I tried it both ways, pre and post to the opening and writing of the streams but nothing helped. And yes, I'm sorry, I should have removed the HTML as well, it just muddled my intentions.
None the less, I found the solution myself, as it appears that placing the code for piping of excel data (or all binary data for that matter) in the jsp page itself is not desirable. The minute I did the exact same thing in my servlet class, I had the proper output read from the stream.