Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Help required in Exporting to Excel in Struts-Portlet

 
Ankit Gandhi
Greenhorn
Posts: 27
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

We are extracting data from database tables and displaying that data in Table format on JSP page. We need to export that data to Excel file in the same format.

For that we also need to display �open/save dialogue box�.

I have written a trial code for same in plain JSP which is working properly.

But in our application we are using struts-portlet framework for which the same code is not working.

For this we have a link �Download File� on the page where we are displaying table.

<html:link page="/jsp/ebip/ebipadmin/applicationadmin/reports/ExlListByApp.jsp">Download File</html:link>

File �ExlListByApp.jsp� contains the following code �





We are getting an exception when it tries to execute following code snippet �



The Exception that we are getting is as follows � (This is just a small part of the stack.)

Nested Exception is java.lang.IllegalArgumentException: application/vnd.ms-excel
at org.apache.pluto.core.impl.RenderResponseImpl.setContentType(RenderResponseImpl.java:151)
at javax.servlet.ServletResponseWrapper.setContentType(ServletResponseWrapper.java:164)
at org.apache.jsp._ExlListByApp._jspService(_ExlListByApp.java:78)
at com.ibm.ws.webcontainer.jsp.runtime.HttpJspBase.service(HttpJspBase.java:89)
at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
at com.ibm.ws.webcontainer.jsp.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:344)
at com.ibm.ws.webcontainer.jsp.servlet.JspServlet.serviceJspFile(JspServlet.java:683)
at com.ibm.ws.webcontainer.jsp.servlet.JspServlet.service(JspServlet.java:781)
at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java(Compiled Code))
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java(Compiled Code))
at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java(Inlined Compiled Code))
at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java(Compiled Code))
at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java(Compiled Code))
at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java(Inlined Compiled Code))
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java(Compiled Code))
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java(Compiled Code))
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.include(WebAppRequestDispatcher.java:257)
at org.apache.pluto.core.impl.PortletRequestDispatcherImpl.include(PortletRequestDispatcherImpl.java:112)
at com.ibm.wps.standard.struts.util.WpsStrutsUtil.include(WpsStrutsUtil.java:2092)
at com.ibm.portal.struts.command.StrutsViewJspCommand.includeURL(StrutsViewJspCommand.java:186)
at com.ibm.portal.struts.command.StrutsViewJspCommand.execute(StrutsViewJspCommand.java:154)
at com.ibm.wps.standard.struts.util.WpsStrutsUtil.executeCommand(WpsStrutsUtil.java:1270)
at com.ibm.wps.standard.struts.util.WpsStrutsUtil.executeCommand(WpsStrutsUtil.java:1229)
at com.ibm.wps.standard.struts.util.WpsStrutsUtil.executeSavedCommand(WpsStrutsUtil.java:1144)
at com.ibm.portal.struts.portlet.StrutsPortlet.doService(StrutsPortlet.java:1128)
at com.ibm.portal.struts.portlet.StrutsPortlet.doView(StrutsPortlet.java:1182)
at javax.portlet.GenericPortlet.doDispatch(GenericPortlet.java:235)
at javax.portlet.GenericPortlet.render(GenericPortlet.java:163)


Any help would be appreciated
 
pulijala hari
Ranch Hand
Posts: 70
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

I am also getting the same error?
Can you pls post how you were able to solve this issue?

regards,
hari
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic