on 08-04-2011 11:23 AM
Dear Experts ,
I am trying to export a table data to excel .
I have included 3jar files :
poi-scratchpad-3.1-FINAL-20080629.jar
poi-3.1-FINAL-20080629.jar
poi-contrib-3.1-FINAL-20080629.jar
in external library dc and included it in my main dc.
Now when I deploy my dc I get the error :
java.lang.NoClassDefFoundError: org/apache/poi/hssf/usermodel/HSSFWorkbook
at com.sap.vendor.SearchVendor.Export_to_excel(SearchVendor.java:336)
at com.sap.vendor.wdp.InternalSearchVendor.Export_to_excel(InternalSearchVendor.java:327)
at com.sap.vendor.VendorDetailsView.onActionExport_Data(VendorDetailsView.java:194)
at com.sap.vendor.wdp.InternalVendorDetailsView.wdInvokeEventHandler(InternalVendorDetailsView.java:258)
at com.sap.tc.webdynpro.progmodel.generation.DelegatingView.invokeEventHandler(DelegatingView.java:87)
Please help.
Try deploying the library DC first. Then deploy your DC project. If still doesn't work, get the default trace and paste here, so somebody can give you more ideas.
Hope this helps.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi There,
If you can build your Web Dynpro project, I believe you missed the POI library in the DC. Please check link: http://www.sapgeek.net/2010/10/web-dynpro-java-use-external-library/.
If you have any questions on POI, you can check http://www.sapgeek.net/2010/10/web-dynpro-java-generate-the-excel-file/
Regards,
Andy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
System is not able to find the class HSSFWorkbook.
Make sure you have created,configured and deployed the external library properly.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Mamai,
For creation and usage of External Library Projects into DCs you can refer to Bala's [blog|http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/4512] [original link is broken] [original link is broken] [original link is broken];
Please look at these documents
[HSSFWorkbook Error|/thread/883398 [original link is broken]; and [exprt a table data in Excel sheet|/thread/1724557 [original link is broken];
Has worked for me in similar problem.
I hope this is help full for you,
Regards
Vijay
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.