Export to excel Issues

[Former Member]

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.

[Former Member · Accepted solution]

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.

[Former Member]

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

[Former Member]

System is not able to find the class HSSFWorkbook.

Make sure you have created,configured and deployed the external library properly.

[vijay_kumar49]

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