POI jars files for Excel Sheet

[Former Member]

Hi All,

I am trying to display the content of a table in an excel sheet in WebDynpro Java as export to excel.

In order to achive that, I have used 3 POI jar files ,poi-3.1-FINAL-20080629.jar , poi-contrib-3.1-FINAL-20080629.jar and poi-scratchpad-3.1-FINAL-20080629.jar.

I have added the same to my application in the build path. Also placed the jar files in the Libraries folder of the server.

However each time I run the application, I get the below error -

1. java.lang.NoClassDefFoundError: org/apache/poi/hssf/usermodel/HSSFWorkbook.

Please help me out to fix this error.

Thanks in advance!!

Regards

Smita

[udaykumar_kanike · Accepted solution]

Hi Smita,

         Follow the below thread, it explains all the scenarios in details including links to create external  library DC.

http://scn.sap.com/thread/2126000

Hope it helps.

Regards

Uday

[Former Member]

Add runtime references to JAR from your WD application

[SandipAgarwalla]

is it a local web dynpro or a DC based project?

how have you reference the JAR files?

[Former Member]

Hi,

Kindly try below link :

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/4210

Praveen

[junwu]

it is asked tons of times

search "how to use external lib"

you will find the answer.