March 22nd, 2011, 01:44 PM
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.
March 23rd, 2011, 12:00 PM
Re: Export Excel which has more than 1 worksheet
Cross-posted in Java Forums.
Please don't cross-post without including links to the other posts.
No matter how far down the wrong road you have gone, turn back now...
Please use [CODE]...your code here...[/CODE] tags when posting code. If you get an error, please post the full error message and stack trace, if present.
Click Here to Expand Forum to Full Width