Exporting to 2 different work sheet of excel
Brought to you by:
fgiust
Menu
▾
▴
We have a requirement to export the content of JSP to excel.
we are using display tag and HTML tags in the same JSP page. Display tag content should be exported to one work sheet and contents generated by HTML tags and encompassing display table should be exported to another work sheet of the execel file. Is there any way to achieve this?
Can anyone please give me solutuion since this is the urgent and we need to give clarification to client as soon as possible.
Basically displaytag will not do this. There's really no reason why it should or would even be able to. Everything outside of <display:table> is outside of the scope of the displaytag library.
You should look at the Jakarta POI libraries for handling this:
http://jakarta.apache.org/poi
Basically this gives you a LOT more control over the export process than displaytag on its own does. I never answer or really even look at any of the export questions on this forum or the mailing list because I almost never use the displaytag export function, but just use POI instead.