Exporting data into excel

[Former Member]

Hi all.

I used the tutorial 'Exporting Context Data into Excel Using the Web Dynpro Binary Cache', to export data of mi app to excel and it raise an exception when i try to export data, the excetion is:

java.lang.NoSuchMethodError: java.lang.StringBuffer.append(Ljava/lang/String;)Ljava/lang/AbstractStringBuilder;

at com.inelectra.pct.ExcelExportComp.trimHeaderText(ExcelExportComp.java:330)

at com.inelectra.pct.ExcelExportComp.trimHeaderTexts(ExcelExportComp.java:313)

at com.inelectra.pct.ExcelExportComp.toExcel(ExcelExportComp.java:254)

at com.inelectra.pct.ExcelExportComp.exportToExcel2003(ExcelExportComp.java:192)

at com.inelectra.pct.wdp.InternalExcelExportComp.exportToExcel2003(InternalExcelExportComp.java:140)

at com.inelectra.pct.ExcelExportCompInterface.exportToExcel2003(ExcelExportCompInterface.java:118)

at com.inelectra.pct.wdp.InternalExcelExportCompInterface.exportToExcel2003(InternalExcelExportCompInterface.java:121)

at com.inelectra.pct.wdp.InternalExcelExportCompInterface$External.exportToExcel2003(InternalExcelExportCompInterface.java:165)

at com.inelectra.pct.ConsultaView.onActionexportToExcel(ConsultaView.java:1001)

at com.inelectra.pct.wdp.InternalConsultaView.wdInvokeEventHandler(InternalConsultaView.java:210)

at com.sap.tc.webdynpro.progmodel.generation.DelegatingView.invokeEventHandler(DelegatingView.java:87)

at com.sap.tc.webdynpro.progmodel.controller.Action.fire(Action.java:67)

at com.sap.tc.webdynpro.clientserver.task.WebDynproMainTask.handleAction(WebDynproMainTask.java:100)

at com.sap.tc.webdynpro.clientserver.task.WebDynproMainTask.handleActionEvent(WebDynproMainTask.java:299)

at com.sap.tc.webdynpro.clientserver.task.WebDynproMainTask.execute(WebDynproMainTask.java:635)

at com.sap.tc.webdynpro.clientserver.cal.AbstractClient.executeTasks(AbstractClient.java:59)

at com.sap.tc.webdynpro.clientserver.cal.ClientManager.doProcessing(ClientManager.java:249)

at com.sap.tc.webdynpro.serverimpl.defaultimpl.DispatcherServlet.doWebDynproProcessing(DispatcherServlet.java:154)

at com.sap.tc.webdynpro.serverimpl.defaultimpl.DispatcherServlet.doContent(DispatcherServlet.java:116)

at com.sap.tc.webdynpro.serverimpl.defaultimpl.DispatcherServlet.doPost(DispatcherServlet.java:55)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.runServlet(HttpHandlerImpl.java:385)

at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.handleRequest(HttpHandlerImpl.java:263)

at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:340)

at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:318)

at com.sap.engine.services.httpserver.server.RequestAnalizer.invokeWebContainer(RequestAnalizer.java:821)

at com.sap.engine.services.httpserver.server.RequestAnalizer.handle(RequestAnalizer.java:239)

at com.sap.engine.services.httpserver.server.Client.handle(Client.java:92)

at com.sap.engine.services.httpserver.server.Processor.request(Processor.java:147)

at com.sap.engine.core.service630.context.cluster.session.ApplicationSessionMessageListener.process(ApplicationSessionMessageListener.java:37)

at com.sap.engine.core.cluster.impl6.session.UnorderedChannel$MessageRunner.run(UnorderedChannel.java:71)

at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37)

at java.security.AccessController.doPrivileged(Native Method)

at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:94)

at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:162)

I have was 6.40 sp9 and java jsdk1.4.2_06-b03.

I dont know whats happening.

I hope somebody can help me fix this error.

Thx and Rgds.

Gregory

[Former Member]

answered

[Former Member]

Hi Gregory,

Check this link out

Hope this helps you

Regards

Rohit

[Former Member]

StringBuilder is a class introduced with JDK 1.5. How has the ExcelExportComp component been compiled?

Try to rebuild the component with JDK 1.4.

Armin

[Former Member]

Hi,

That class might be missing..

Instead of using StringBuffer class to add the XML elements you can use String and say "+" to add the string values..

Regards

Bharathwaj