Export dynamic table gen in jsp to excel
karthika nair
Greenhorn
Posts: 5
posted 6 years ago
Hello,
i have a jsp page that generates an html table dynamically and i want to export this table to excel on click of a button after the table has been viewed on the browser.
Solutions I have tried:
1)i read about the response.setContentType("application/vnd.ms-excel"),but how do i use a button to do this and export only that table and not any other data.
2)I tried javascript also but it works only with static table.
Now the only possible soln I feel is to somehow get only the table included in a new jsp and then use 1st option on the new page.But the problem is i don't know how to include only the table under div tag in a new jsp page?
Wish to get the solution soon.
Thanks
i have a jsp page that generates an html table dynamically and i want to export this table to excel on click of a button after the table has been viewed on the browser.
Solutions I have tried:
1)i read about the response.setContentType("application/vnd.ms-excel"),but how do i use a button to do this and export only that table and not any other data.
2)I tried javascript also but it works only with static table.
Now the only possible soln I feel is to somehow get only the table included in a new jsp and then use 1st option on the new page.But the problem is i don't know how to include only the table under div tag in a new jsp page?
Wish to get the solution soon.
Thanks
karthika nair
Greenhorn
Posts: 5
karthika nair
Greenhorn
Posts: 5
posted 6 years ago
I had tried exactly this,but it does not show the dynamicly gen result but instead displays the code with scriptlets that I had written in order to get the desired output.
Pl. somehow get a solution to include only a fragment of a page ie table in another jsp page like we use <jsp:include> or <@include> directive
Pl. somehow get a solution to include only a fragment of a page ie table in another jsp page like we use <jsp:include> or <@include> directive
posted 6 years ago
May be you could do something like this
page1.jsp
----------
page2.jsp
--------
I have used scriptlets, but we should not. Better to use el, jstl.
page1.jsp
----------
page2.jsp
--------
I have used scriptlets, but we should not. Better to use el, jstl.
Swastik
karthika nair
Greenhorn
Posts: 5
posted 6 years ago
Thanks a lot Swastik for taking time and working on grey cells to find a solution.You solved my problem partially. 
The problem is I have many reports to be generated containing these kind of tables and at the end on the last row I have computed the total and stuff like that.So I can't create a common loop structure for all the reports as shown in your page2.jsp
So what I wanted was a common page with response type set to excel which all these reports can refer.
Below is given a common code that I am using to print the reports.Notice the use of div tag.I want something similar to it to work for my export feature as well like a jsp that can include just the contents of the div tag,etc
Pl. find a solution soon ...
The problem is I have many reports to be generated containing these kind of tables and at the end on the last row I have computed the total and stuff like that.So I can't create a common loop structure for all the reports as shown in your page2.jsp
So what I wanted was a common page with response type set to excel which all these reports can refer.
Below is given a common code that I am using to print the reports.Notice the use of div tag.I want something similar to it to work for my export feature as well like a jsp that can include just the contents of the div tag,etc
Pl. find a solution soon ...
