Export Excel which has more than 1 worksheet
Guys,
Anyone has any idea how to generate & stream an excel sheet in jsp.
Please note: The excel sheet will have two worksheets inside & we should stream out the excel sheet to the user on JSP itself without storing the excel file on the applicatoin server.
Action I performed: Our source is 2 csv files. I have used CSVReader to read those files & create excel sheet with two tabs using POI Libraries which is causing me to store excel sheet on the server.
Need Help:
How to generate an excel sheet which has more than one worksheets using JSP & also how to set that in the response.header ? Please advice
Please let me know if my requirements are not clear. Appreiate your help.
Re: Export Excel which has more than 1 worksheet
I believe POI has the ability to write to any OutputStream, so you should be able to specify the outputstream of the jsp/servlet OutputStream itself. Prior, set the response.header Content-Type...for excel I'm not sure off the top of my head but you should be able to find it from google.