Export Excel which has more than 1 worksheet
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.
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.