export to excel from richfaces is not working with latest seam jar files

[sureshgudapati]

hi,

i am using following jarfiles for excel export web application:

jboss-seam2.1
1)jboss-seam-excel.jar 2)jboss-seam.jar 3)jboss-seam-ui.jar 4)jboss-el.jar

richfaces-3.2.1
1)richfaces-api-3.2.1.GA.jar 2)richfaces-impl-3.2.1.GA.jar 3)richfaces-ui-3.2.1.GA.jar

But i am getting following error:

Error logs: The class 'org.jboss.seam.Namespace' does not have the property 'excelExporter'

Could you please provide me the help on this issue? how to resolve this,... what jar files i need to use? and special setting on need to made on web.xml??

[sureshgudapati]

Full Error Message:

ERROR webapp.BaseXMLFilter (org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:157))     - Exception in the filter chain
javax.servlet.ServletException: #{org.jboss.seam.excel.excelExporter.export('emailreport:emailList')}: javax.el.PropertyNotFoundException: /pages/dealPlacedBy.jsp @238,143
action="#{org.jboss.seam.excel.excelExporter.export('emailreport:emailList')}": The class 'org.jboss.seam.Namespace' does not have the property 'excelExporter'.
        at javax.faces.webapp.FacesServlet.service(FacesServlet.java:277)
        at org.apache.catalina.core.ApplicationFilterChain.servletService(ApplicationFilterChain.java:431)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:337)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:218)
        at com.fidintl.websupport.business.webmodule.session.SessionTimeoutFilter.doFilter(SessionTimeoutFilter.java:58)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:250)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:218)
        at org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:508)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:250)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:218)
        at com.fidintl.websupport.business.webmodule.session.SessionIdLoggingFilter.doFilter(SessionIdLoggingFilter.java:36)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:250)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:218)
        at com.fidintl.websupport.business.webmodule.session.SessionIdLoggingFilter.doFilter(SessionIdLoggingFilter.java:36)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:250)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:218)
        at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:83)
        at org.jboss.seam.web.IdentityFilter.doFilter(IdentityFilter.java:38)
        at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
        at org.jboss.seam.web.MultipartFilter.doFilter(MultipartFilter.java:90)
        at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
        at org.jboss.seam.web.ExceptionFilter.doFilter(ExceptionFilter.java:64)
        at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
        at org.jboss.seam.web.RedirectFilter.doFilter(RedirectFilter.java:45)
        at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
        at org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:154)
        at org.ajax4jsf.webapp.BaseFilter.handleRequest(BaseFilter.java:260)
        at org.ajax4jsf.webapp.BaseFilter.processUploadsAndHandleRequest(BaseFilter.java:366)
        at org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:493)
        at org.jboss.seam.web.Ajax4jsfFilter.doFilter(Ajax4jsfFilter.java:56)
        at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
        at org.jboss.seam.web.LoggingFilter.doFilter(LoggingFilter.java:58)
        at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
        at org.jboss.seam.servlet.SeamFilter.doFilter(SeamFilter.java:158)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:250)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:218)
        at org.apache.catalina.core.StandardWrapperValve.preInvoke(StandardWrapperValve.java:460)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:139)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:186)
        at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:719)
        at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:657)
        at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:96)
        at com.sun.enterprise.web.PESessionLockingStandardPipeline.invoke(PESessionLockingStandardPipeline.java:98)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:187)
        at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:719)
        at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:657)
        at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:651)
        at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1030)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:142)
        at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:719)
        at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:657)
        at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:651)
        at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1030)
        at org.apache.catalina.connector.CoyoteAdapter.doService(CoyoteAdapter.java:316)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:235)
        at com.sun.enterprise.v3.services.impl.ContainerMapper.service(ContainerMapper.java:180)
        at com.sun.grizzly.http.DefaultProcessorTask.invokeAdapter(DefaultProcessorTask.java:625)
        at com.sun.grizzly.http.DefaultProcessorTask.doProcess(DefaultProcessorTask.java:562)
        at com.sun.grizzly.http.DefaultProcessorTask.process(DefaultProcessorTask.java:819)
        at com.sun.grizzly.http.DefaultProtocolFilter.execute(DefaultProtocolFilter.java:152)
        at com.sun.enterprise.v3.services.impl.GlassfishProtocolChain.executeProtocolFilter(GlassfishProtocolChain.java:71)
        at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:103)
        at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:89)
        at com.sun.grizzly.http.HttpProtocolChain.execute(HttpProtocolChain.java:76)
        at com.sun.grizzly.ProtocolChainContextTask.doCall(ProtocolChainContextTask.java:67)
        at com.sun.grizzly.SelectionKeyContextTask.call(SelectionKeyContextTask.java:56)
        at com.sun.grizzly.util.WorkerThreadImpl.processTask(WorkerThreadImpl.java:325)
        at com.sun.grizzly.util.WorkerThreadImpl.run(WorkerThreadImpl.java:184)
Caused by: javax.faces.FacesException: #{org.jboss.seam.excel.excelExporter.export('emailreport:emailList')}: javax.el.PropertyNotFoundException: /pages/dealPlacedBy.jsp @238,143 action="#{org.jboss.seam.excel.excelExporter.export('emailreport:emailList')}": The class 'org.jboss.seam.Namespace' does not have the property 'excelExporter'.
        at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:118)
        at javax.faces.component.UICommand.broadcast(UICommand.java:387)
        at org.ajax4jsf.component.AjaxViewRoot.processEvents(AjaxViewRoot.java:317)
        at org.ajax4jsf.component.AjaxViewRoot.broadcastEvents(AjaxViewRoot.java:292)
        at org.ajax4jsf.component.AjaxViewRoot.processPhase(AjaxViewRoot.java:249)
        at org.ajax4jsf.component.AjaxViewRoot.processApplication(AjaxViewRoot.java:462)
        at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:82)
        at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:100)
        at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118)
        at javax.faces.webapp.FacesServlet.service(FacesServlet.java:265)
        ... 67 more
Caused by: javax.faces.el.EvaluationException: javax.el.PropertyNotFoundException: /pages/dealPlacedBy.jsp @238,143 action="#{org.jboss.seam.excel.excelExporter.export('emailreport:emailList')}": The class 'org.jboss.seam.Namespace' does not have the property 'excelExporter'.
        at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:95)
        at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102)
        ... 76 more
Caused by: javax.el.PropertyNotFoundException: /pages/dealPlacedBy.jsp @238,143 action="#{org.jboss.seam.excel.excelExporter.export('emailreport:emailList')}": The class 'org.jboss.seam.Namespace' does not have the property 'excelExporter'.
        at com.sun.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:70)
        at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:88)
        ... 77 more

[nickarls]

Check what your components.xml in the main jar META-INF says around

  <import>org.jboss.seam.excel.exporter</import>

[danielc.roth]

I just tested the excel example on seam-2.1.0.SP1. It worked fine on jboss as 4.2.2.

[sureshgudapati]

Example is showing following code:

<h:commandLink value="Example" rendered="#{!empty excelTest.result}" action="#{excelExporter.export('excelExport:excelTable')}" />

But if i want to import " org.jboss.seam.excel.exporter" directly into JSF page then, How do i need to specify????
<h:commandLink value="Export" action="#{org.jboss.seam.excel.exporter('emailreport:emailList')}"/>

????

this is giving following error....

Caused by: javax.el.MethodNotFoundException: /pages/dealPlacedBy.jsp @238,131 action="#{org.jboss.seam.excel.exporter('emailreport:emailList')}": Method not found: Namespace(org.jboss.seam.excel.).exporter(java.lang.String)
        at com.sun.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:72)
        at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:88)
        ... 77 more

[nickarls]

org.jboss.seam.excel.exporter.excelExporter.export('emailreport:emailList')

But I don't get why your alias isn't picked up.

[sureshgudapati]

Thanks for yourreply...
But i am getting following exceptions....

if i use this code...

  <h:commandLink value="Export table as Excel spreadsheet"
                                                   action="#{excelExporter.export('excelExport:excelTable')}" />
                                    <br />
                                    <h:commandLink value="Export table as CSV"
                                                   action="#{excelExporter.export('excelExport:excelTable','csv')}" />
                                    <br />
                                    <h:commandLink value="Export table as Excel spreadsheet"
                                                   action="#{org.jboss.seam.excel.exporter.excelExporter.export('excelExport:excelTable')}" />
                                    <br />








Error log:


SEVERE: JSF1054: (Phase ID: PROCESS_VALIDATIONS 3, View ID: /pages/dealPlacedBy.jsp) Exception thrown during phase execution: javax.faces.event.PhaseEvent[source=com.sun.faces.lifecycle.LifecycleImpl@943b29]
SEVERE: StandardWrapperValve[Faces Servlet]: PWC1406: Servlet.service() for servlet Faces Servlet threw exception
javax.el.PropertyNotFoundException: /pages/dealPlacedBy.jsp @201,50 value="#{excelTest.searchWord}": Target Unreachable, identifier 'excelTest' resolved to null
        at com.sun.facelets.el.TagValueExpression.getType(TagValueExpression.java:62)
        at com.sun.faces.renderkit.html_basic.HtmlBasicInputRenderer.getConvertedValue(HtmlBasicInputRenderer.java:92)
        at javax.faces.component.UIInput.getConvertedValue(UIInput.java:942)
        at javax.faces.component.UIInput.validate(UIInput.java:868)
        at javax.faces.component.UIInput.executeValidate(UIInput.java:1072)
        at javax.faces.component.UIInput.processValidators(UIInput.java:672)
        at javax.faces.component.UIForm.processValidators(UIForm.java:235)
        at javax.faces.component.UIComponentBase.processValidators(UIComponentBase.java:1058)
        at org.ajax4jsf.component.AjaxViewRoot$3.invokeContextCallback(AjaxViewRoot.java:435)
        at org.ajax4jsf.component.AjaxViewRoot.processPhase(AjaxViewRoot.java:235)
        at org.ajax4jsf.component.AjaxViewRoot.processValidators(AjaxViewRoot.java:451)
        at com.sun.faces.lifecycle.ProcessValidationsPhase.execute(ProcessValidationsPhase.java:76)
        at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:100)
        at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118)
        at javax.faces.webapp.FacesServlet.service(FacesServlet.java:265)
        at org.apache.catalina.core.ApplicationFilterChain.servletService(ApplicationFilterChain.java:431)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:337)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:218)
        at com.fidintl.websupport.business.webmodule.session.SessionTimeoutFilter.doFilter(SessionTimeoutFilter.java:58)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:250)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:218)
        at org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:508)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:250)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:218)
        at com.fidintl.websupport.business.webmodule.session.SessionIdLoggingFilter.doFilter(SessionIdLoggingFilter.java:36)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:250)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:218)
        at com.fidintl.websupport.business.webmodule.session.SessionIdLoggingFilter.doFilter(SessionIdLoggingFilter.java:36)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:250)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:218)
        at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:83)
        at org.jboss.seam.web.IdentityFilter.doFilter(IdentityFilter.java:38)
        at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
        at org.jboss.seam.web.MultipartFilter.doFilter(MultipartFilter.java:90)
        at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
        at org.jboss.seam.web.ExceptionFilter.doFilter(ExceptionFilter.java:64)
        at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
        at org.jboss.seam.web.RedirectFilter.doFilter(RedirectFilter.java:45)
        at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
        at org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:154)
        at org.ajax4jsf.webapp.BaseFilter.handleRequest(BaseFilter.java:260)
        at org.ajax4jsf.webapp.BaseFilter.processUploadsAndHandleRequest(BaseFilter.java:366)
        at org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:493)
        at org.jboss.seam.web.Ajax4jsfFilter.doFilter(Ajax4jsfFilter.java:56)
        at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
        at org.jboss.seam.web.LoggingFilter.doFilter(LoggingFilter.java:58)
        at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
        at org.jboss.seam.servlet.SeamFilter.doFilter(SeamFilter.java:158)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:250)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:218)
        at org.apache.catalina.core.StandardWrapperValve.preInvoke(StandardWrapperValve.java:460)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:139)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:186)
        at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:719)
        at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:657)
        at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:96)
        at com.sun.enterprise.web.PESessionLockingStandardPipeline.invoke(PESessionLockingStandardPipeline.java:98)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:187)
        at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:719)
        at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:657)
        at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:651)
        at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1030)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:142)
        at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:719)
        at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:657)
        at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:651)
        at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1030)
        at org.apache.catalina.connector.CoyoteAdapter.doService(CoyoteAdapter.java:316)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:235)
        at com.sun.enterprise.v3.services.impl.ContainerMapper.service(ContainerMapper.java:180)
        at com.sun.grizzly.http.DefaultProcessorTask.invokeAdapter(DefaultProcessorTask.java:625)
        at com.sun.grizzly.http.DefaultProcessorTask.doProcess(DefaultProcessorTask.java:562)
        at com.sun.grizzly.http.DefaultProcessorTask.process(DefaultProcessorTask.java:819)
        at com.sun.grizzly.http.DefaultProtocolFilter.execute(DefaultProtocolFilter.java:152)
        at com.sun.enterprise.v3.services.impl.GlassfishProtocolChain.executeProtocolFilter(GlassfishProtocolChain.java:71)
        at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:103)
        at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:89)
        at com.sun.grizzly.http.HttpProtocolChain.execute(HttpProtocolChain.java:76)
        at com.sun.grizzly.ProtocolChainContextTask.doCall(ProtocolChainContextTask.java:67)
        at com.sun.grizzly.SelectionKeyContextTask.call(SelectionKeyContextTask.java:56)
        at com.sun.grizzly.util.WorkerThreadImpl.processTask(WorkerThreadImpl.java:325)
        at com.sun.grizzly.util.WorkerThreadImpl.run(WorkerThreadImpl.java:184)

[nickarls]

javax.el.PropertyNotFoundException: /pages/dealPlacedBy.jsp @201,50 value="#{excelTest.searchWord}": Target Unreachable, identifier 'excelTest' resolved to null

seems to have more with your excelTest bean and not the export?

[sureshgudapati]

sorry.... by mistaken i sent the above log... i have corrected that JSP and removed excelTest bean and hard coded those values...


<h:form id="excelExport">
          <a4j:outputPanel id="searchResults">
               <rich:dataTable id="excelTable"
                    style="xls-font: red bold 22 Verdana; xls-column-widths: 8000 9000 10000"
                    columnClasses="left, right" width="500px">
                    <rich:column>
                         <f:facet name="header">
                              <h:outputText value="Name" style="xls-font: italic"/>
                         </f:facet>
                         <h:outputText value="Surya" />
                    </rich:column>
                    <rich:column>
                         <f:facet name="header">
                              <h:outputText value="Company" />
                         </f:facet>
                         <h:outputText value="Fidelity" />
                    </rich:column>
                    <rich:column>
                         <f:facet name="header">
                              <h:outputText value="Working on" />
                         </f:facet>
                         <h:outputText value="AppRecovery" />
                    </rich:column>
               </rich:dataTable>
               <h:commandLink value="Export table as Excel spreadsheet"
                    action="#{excelExporter.export('excelExport:excelTable')}" />
               <br />
               <h:commandLink value="Export table as CSV"
                    action="#{excelExporter.export('excelExport:excelTable','csv')}" />
          </a4j:outputPanel>

     </h:form>




Error Logs:

SEVERE: JSF1054: (Phase ID: PROCESS_VALIDATIONS 3, View ID: /pages/dealPlacedBy.jsp) Exception thrown during phase execution: javax.faces.event.PhaseEvent[source=com.sun.faces.lifecycle.LifecycleImpl@2a9403]
SEVERE: StandardWrapperValve[Faces Servlet]: PWC1406: Servlet.service() for servlet Faces Servlet threw exception
javax.el.PropertyNotFoundException: /pages/dealPlacedBy.jsp @204,80 value="#{excelTest.searchWord}": Target Unreachable, identifier 'excelTest' resolved to null
        at com.sun.facelets.el.TagValueExpression.getType(TagValueExpression.java:62)
        at com.sun.faces.renderkit.html_basic.HtmlBasicInputRenderer.getConvertedValue(HtmlBasicInputRenderer.java:92)
        at javax.faces.component.UIInput.getConvertedValue(UIInput.java:942)
        at javax.faces.component.UIInput.validate(UIInput.java:868)
        at javax.faces.component.UIInput.executeValidate(UIInput.java:1072)
        at javax.faces.component.UIInput.processValidators(UIInput.java:672)
        at javax.faces.component.UIForm.processValidators(UIForm.java:235)
        at javax.faces.component.UIComponentBase.processValidators(UIComponentBase.java:1058)
        at org.ajax4jsf.component.AjaxViewRoot$3.invokeContextCallback(AjaxViewRoot.java:435)
        at org.ajax4jsf.component.AjaxViewRoot.processPhase(AjaxViewRoot.java:235)
        at org.ajax4jsf.component.AjaxViewRoot.processValidators(AjaxViewRoot.java:451)
        at com.sun.faces.lifecycle.ProcessValidationsPhase.execute(ProcessValidationsPhase.java:76)
        at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:100)
        at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118)
        at javax.faces.webapp.FacesServlet.service(FacesServlet.java:265)
        at org.apache.catalina.core.ApplicationFilterChain.servletService(ApplicationFilterChain.java:431)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:337)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:218)
        at com.fidintl.websupport.business.webmodule.session.SessionTimeoutFilter.doFilter(SessionTimeoutFilter.java:58)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:250)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:218)
        at org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:508)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:250)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:218)
        at com.fidintl.websupport.business.webmodule.session.SessionIdLoggingFilter.doFilter(SessionIdLoggingFilter.java:36)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:250)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:218)
        at com.fidintl.websupport.business.webmodule.session.SessionIdLoggingFilter.doFilter(SessionIdLoggingFilter.java:36)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:250)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:218)
        at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:83)
        at org.jboss.seam.web.IdentityFilter.doFilter(IdentityFilter.java:38)
        at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
        at org.jboss.seam.web.MultipartFilter.doFilter(MultipartFilter.java:90)
        at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
        at org.jboss.seam.web.ExceptionFilter.doFilter(ExceptionFilter.java:64)
        at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
        at org.jboss.seam.web.RedirectFilter.doFilter(RedirectFilter.java:45)
        at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
        at org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:154)
        at org.ajax4jsf.webapp.BaseFilter.handleRequest(BaseFilter.java:260)
        at org.ajax4jsf.webapp.BaseFilter.processUploadsAndHandleRequest(BaseFilter.java:366)
        at org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:493)
        at org.jboss.seam.web.Ajax4jsfFilter.doFilter(Ajax4jsfFilter.java:56)
        at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
        at org.jboss.seam.web.LoggingFilter.doFilter(LoggingFilter.java:58)
        at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
        at org.jboss.seam.servlet.SeamFilter.doFilter(SeamFilter.java:158)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:250)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:218)
        at org.apache.catalina.core.StandardWrapperValve.preInvoke(StandardWrapperValve.java:460)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:139)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:186)
        at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:719)
        at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:657)
        at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:96)
        at com.sun.enterprise.web.PESessionLockingStandardPipeline.invoke(PESessionLockingStandardPipeline.java:98)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:187)
        at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:719)
        at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:657)
        at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:651)
        at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1030)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:142)
        at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:719)
        at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:657)
        at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:651)
        at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1030)
        at org.apache.catalina.connector.CoyoteAdapter.doService(CoyoteAdapter.java:316)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:235)
        at com.sun.enterprise.v3.services.impl.ContainerMapper.service(ContainerMapper.java:180)
        at com.sun.grizzly.http.DefaultProcessorTask.invokeAdapter(DefaultProcessorTask.java:625)
        at com.sun.grizzly.http.DefaultProcessorTask.doProcess(DefaultProcessorTask.java:562)
        at com.sun.grizzly.http.DefaultProcessorTask.process(DefaultProcessorTask.java:819)
        at com.sun.grizzly.http.DefaultProtocolFilter.execute(DefaultProtocolFilter.java:152)
        at com.sun.enterprise.v3.services.impl.GlassfishProtocolChain.executeProtocolFilter(GlassfishProtocolChain.java:71)
        at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:103)
        at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:89)
        at com.sun.grizzly.http.HttpProtocolChain.execute(HttpProtocolChain.java:76)
        at com.sun.grizzly.ProtocolChainContextTask.doCall(ProtocolChainContextTask.java:67)
        at com.sun.grizzly.SelectionKeyContextTask.call(SelectionKeyContextTask.java:56)
        at com.sun.grizzly.util.WorkerThreadImpl.processTask(WorkerThreadImpl.java:325)
        at com.sun.grizzly.util.WorkerThreadImpl.run(WorkerThreadImpl.java:184)

[sureshgudapati]

<blockquote>
_suresh gudapati wrote on Nov 05, 2008 11:28:_<br/>

sorry.... by mistaken i sent the above log... i have corrected that JSP and removed excelTest bean and hard coded those values...


<h:form id="excelExport">
                                   <br />
                                <a4j:outputPanel id="searchResults">
                                    <rich:dataTable id="excelTable"
                                                    style="xls-font: 10 Verdana; xls-column-widths: 8000 9000 10000"
                                                    columnClasses="left, right" width="500px">
                                        <rich:column>
                                            <f:facet name="header">
                                                <h:outputText value="Name" style="xls-font: red bold"/>
                                            </f:facet>
                                            <h:outputText value="Surya999" />
                                        </rich:column>
                                        <rich:column>
                                            <f:facet name="header">
                                                <h:outputText value="Company" style="xls-font: red bold" />
                                            </f:facet>
                                            <h:outputText value="99999" />
                                        </rich:column>
                                        <rich:column>
                                            <f:facet name="header">
                                                <h:outputText value="Working on" style="xls-font: red bold" />
                                            </f:facet>
                                            <h:outputText value="99999" />
                                        </rich:column>
                                    </rich:dataTable>
                                    <h:commandLink value="Export table as Excel spreadsheet"
                                                   action="#{excelExporter.export('excelExport:excelTable')}" />
                                    <br />
                                    <h:commandLink value="Export table as CSV"
                                                   action="#{excelExporter.export('excelExport:excelTable','csv')}" />
                                    <br />
                                    <h:commandLink value="Export table as Excel spreadsheet"
                                                   action="#{org.jboss.seam.excel.exporter.excelExporter.export('excelExport:excelTable')}" />
                                    <br />


                                </a4j:outputPanel>
                            </h:form>



Error Logs:
SEVERE: JSF1054: (Phase ID: INVOKE_APPLICATION 5, View ID: /pages/dealPlacedBy.jsp) Exception thrown during phase execution: javax.faces.event.PhaseEvent[source=com.sun.faces.lifecycle.LifecycleImpl@2a9403]
SEVERE: StandardWrapperValve[Faces Servlet]: PWC1406: Servlet.service() for servlet Faces Servlet threw exception
javax.faces.FacesException: #{org.jboss.seam.excel.exporter.excelExporter.export('excelExport:excelTable')}: org.jboss.seam.excel.ExcelWorkbookException: Could not find data table with id excelExport:excelTable
        at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:118)
        at javax.faces.component.UICommand.broadcast(UICommand.java:387)
        at org.ajax4jsf.component.AjaxViewRoot.processEvents(AjaxViewRoot.java:317)
        at org.ajax4jsf.component.AjaxViewRoot.broadcastEvents(AjaxViewRoot.java:292)
        at org.ajax4jsf.component.AjaxViewRoot.processPhase(AjaxViewRoot.java:249)
        at org.ajax4jsf.component.AjaxViewRoot.processApplication(AjaxViewRoot.java:462)
        at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:82)
        at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:100)
        at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118)
        at javax.faces.webapp.FacesServlet.service(FacesServlet.java:265)
        at org.apache.catalina.core.ApplicationFilterChain.servletService(ApplicationFilterChain.java:431)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:337)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:218)
        at com.fidintl.websupport.business.webmodule.session.SessionTimeoutFilter.doFilter(SessionTimeoutFilter.java:58)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:250)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:218)
        at org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:508)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:250)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:218)
        at com.fidintl.websupport.business.webmodule.session.SessionIdLoggingFilter.doFilter(SessionIdLoggingFilter.java:36)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:250)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:218)
        at com.fidintl.websupport.business.webmodule.session.SessionIdLoggingFilter.doFilter(SessionIdLoggingFilter.java:36)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:250)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:218)
        at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:83)
        at org.jboss.seam.web.IdentityFilter.doFilter(IdentityFilter.java:38)
        at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
        at org.jboss.seam.web.MultipartFilter.doFilter(MultipartFilter.java:90)
        at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
        at org.jboss.seam.web.ExceptionFilter.doFilter(ExceptionFilter.java:64)
        at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
        at org.jboss.seam.web.RedirectFilter.doFilter(RedirectFilter.java:45)
        at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
        at org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:154)
        at org.ajax4jsf.webapp.BaseFilter.handleRequest(BaseFilter.java:260)
        at org.ajax4jsf.webapp.BaseFilter.processUploadsAndHandleRequest(BaseFilter.java:366)
        at org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:493)
        at org.jboss.seam.web.Ajax4jsfFilter.doFilter(Ajax4jsfFilter.java:56)
        at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
        at org.jboss.seam.web.LoggingFilter.doFilter(LoggingFilter.java:58)
        at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
        at org.jboss.seam.servlet.SeamFilter.doFilter(SeamFilter.java:158)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:250)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:218)
        at org.apache.catalina.core.StandardWrapperValve.preInvoke(StandardWrapperValve.java:460)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:139)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:186)
        at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:719)
        at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:657)
        at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:96)
        at com.sun.enterprise.web.PESessionLockingStandardPipeline.invoke(PESessionLockingStandardPipeline.java:98)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:187)
        at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:719)
        at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:657)
        at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:651)
        at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1030)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:142)
        at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:719)
        at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:657)
        at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:651)
        at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1030)
        at org.apache.catalina.connector.CoyoteAdapter.doService(CoyoteAdapter.java:316)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:235)
        at com.sun.enterprise.v3.services.impl.ContainerMapper.service(ContainerMapper.java:180)
        at com.sun.grizzly.http.DefaultProcessorTask.invokeAdapter(DefaultProcessorTask.java:625)
        at com.sun.grizzly.http.DefaultProcessorTask.doProcess(DefaultProcessorTask.java:562)
        at com.sun.grizzly.http.DefaultProcessorTask.process(DefaultProcessorTask.java:819)
        at com.sun.grizzly.http.DefaultProtocolFilter.execute(DefaultProtocolFilter.java:152)
        at com.sun.enterprise.v3.services.impl.GlassfishProtocolChain.executeProtocolFilter(GlassfishProtocolChain.java:71)
        at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:103)
        at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:89)
        at com.sun.grizzly.http.HttpProtocolChain.execute(HttpProtocolChain.java:76)
        at com.sun.grizzly.ProtocolChainContextTask.doCall(ProtocolChainContextTask.java:67)
        at com.sun.grizzly.SelectionKeyContextTask.call(SelectionKeyContextTask.java:56)
        at com.sun.grizzly.util.WorkerThreadImpl.processTask(WorkerThreadImpl.java:325)
        at com.sun.grizzly.util.WorkerThreadImpl.run(WorkerThreadImpl.java:184)
Caused by: javax.faces.el.EvaluationException: org.jboss.seam.excel.ExcelWorkbookException: Could not find data table with id excelExport:excelTable
        at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:102)
        at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102)
        ... 76 more
Caused by: org.jboss.seam.excel.ExcelWorkbookException: Could not find data table with id excelExport:excelTable
        at org.jboss.seam.excel.exporter.ExcelExporter.export(ExcelExporter.java:81)
        at org.jboss.seam.excel.exporter.ExcelExporter.export(ExcelExporter.java:62)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.jboss.el.util.ReflectionUtil.invokeMethod(ReflectionUtil.java:329)
        at org.jboss.el.util.ReflectionUtil.invokeMethod(ReflectionUtil.java:274)
        at org.jboss.el.parser.AstMethodSuffix.getValue(AstMethodSuffix.java:59)
        at org.jboss.el.parser.AstMethodSuffix.invoke(AstMethodSuffix.java:65)
        at org.jboss.el.parser.AstValue.invoke(AstValue.java:96)
        at org.jboss.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:276)
        at com.sun.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:68)
        at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:88)
        ... 77 more

[sureshgudapati]

did i miss any thing on above?

am i using wrong versions of jar files...??

[nickarls]

The stacktrace isn't there just to look pretty:

Caused by: org.jboss.seam.excel.ExcelWorkbookException: Could not find data table with id excelExport:excelTable

Look at the html source and see what the id of the table really is.

[sureshgudapati]

This is my view source of the html:....

why i am getting: table id as....following????

<table class="dr-table rich-table " id="notExpired:excelExport:excelTable" ....>


????



page View source:

<form id="notExpired:excelExport" name="notExpired:excelExport" method="post" action="/UAMWebApp/pages/dealPlacedBy.jsf" enctype="application/x-www-form-urlencoded">
<input type="hidden" name="notExpired:excelExport" value="notExpired:excelExport" />

                                   <br /><span id="notExpired:excelExport:searchResults"><table class="dr-table rich-table " id="notExpired:excelExport:excelTable" style="xls-font: 10 Verdana; xls-column-widths: 8000 9000 10000" border="0" cellpadding="0" cellspacing="0" width="500px"><colgroup span="3"></colgroup><thead class="dr-table-thead"><tr class="dr-table-subheader rich-table-subheader "><th class="dr-table-subheadercell rich-table-subheadercell  " scope="col" id="notExpired:excelExport:excelTable:j_id74header"><div id="notExpired:excelExport:excelTable:j_id74header:sortDiv"><span style="xls-font: red bold">Name</span></div></th><th class="dr-table-subheadercell rich-table-subheadercell  " scope="col" id="notExpired:excelExport:excelTable:j_id77header"><div id="notExpired:excelExport:excelTable:j_id77header:sortDiv"><span style="xls-font: red bold">Company</span></div></th><th class="dr-table-subheadercell rich-table-subheadercell  " scope="col" id="notExpired:excelExport:excelTable:j_id80header"><div id="notExpired:excelExport:excelTable:j_id80header:sortDiv"><span style="xls-font: red bold">Working on</span></div></th></tr></thead><tbody id="notExpired:excelExport:excelTable:tb"></tbody></table><a href="#" onclick="if(typeof jsfcljs == 'function'){jsfcljs(document.getElementById('notExpired:excelExport'),{'notExpired:excelExport:j_id83':'notExpired:excelExport:j_id83'},'');}return false">Export table as Excel spreadsheet</a>
                                    <br /><a href="#" onclick="if(typeof jsfcljs == 'function'){jsfcljs(document.getElementById('notExpired:excelExport'),{'notExpired:excelExport:j_id85':'notExpired:excelExport:j_id85'},'');}return false">Export table as CSV</a>
                                    <br /><a href="#" onclick="if(typeof jsfcljs == 'function'){jsfcljs(document.getElementById('notExpired:excelExport'),{'notExpired:excelExport:j_id87':'notExpired:excelExport:j_id87'},'');}return false">Export table as Excel spreadsheet</a>
             

[nickarls]

No idea. Depends on your view layer. Do you use any cacheing etc?

[sureshgudapati]

no, i am not using any cache ...

i am using latest Rich faces jar along with seam jar file...