REG:ERROR:java.lang.ClassNotFoundException: jxl.format.CellFormat --NWDI

[Former Member]

Hi All,

Currently I have developed a webapplication in a DC .

The NWDS version we are using is NWDS 7.0.14

NWDI version 7.0.18

In the applications we have functionality of downloading to a Excel sheet .Therefore we are using the jxl.jar to support the same.I have added these jars by creating a new DC and then creating the Public parts of the same . The application doesnot throw any exception during the build or deploy but when we run the application i am getting the following error.

ERROR:java.lang.ClassNotFoundException: jxl.format.CellFormat -

---

Loader Info -

---

ClassLoader name: [axis/portal_dev_{dc_cusrep7309_1012] Parent loader name: [Frame ClassLoader] References: common:service:http;service:servlet_jsp service:ejb common:service:iiop;service:naming;service:p4;service:ts service:jmsconnector library:jsse library:servlet common:library:IAIKSecurity;library:activation;library:mail;library:tc}sec_{ssl library:ejb20 library:j2eeca library:jms library:opensql common:library:com.sap.security.api.sda;library:com.sap.security.core.sda;library:security.class;library:webservices_lib;service:adminadapter;service:basicadmin;service:com.sap.security.core.ume.service;service:configuration;service:connector;service:dbpool;service:deploy;service:jmx;service:jmx_notification;service:keystore;service:security;service:userstore interface:resourcecontext_api interface:webservices interface:cross interface:ejbserialization sap.com/tc}wd_{dispwda sap.com/tc}wd_{corecomp service:webdynpro service:webservices service:tc}sec_wssecservice service:sld library:com.sap.aii.util.xml library:jnet library:com.sap.aii.proxy.framework library:tc_{cmi library:com.sap.aii.util.misc library:com.sap.aii.util.rb library:tc}graphics_{igs library:com.sap.util.monitor.jarm library:tc}ddic_{ddicruntime library:com.sap.mw.jco library:core_lib library:com.sap.lcr.api.cimclient library:sapxmltoolkit library:tc}ddic_{ddicservices Resources: /usr/sap/EPD/JC00/j2ee/cluster/server0/apps/axis/portal_dev}dc_cusrep7309_1012/webdynpro/public/lib/app.jar Loading model: {parent,references,local} -

---

Request u'll to help me reslove this issues as we are stuck up with this issue and it is a critical task in our project now.

To bring to your notice the application which donot this jar file have properly got deployed and was also able to run them properly.

Waiting for a prompt reply.

Thanks in Advance

Thanks and Regards,

Nishita Salver

[Former Member · Accepted solution]

Hi,

Follow the below blog to add external jars to a webdynpro dc.

/people/bala.krishnan2/blog/2006/09/25/bid-adieu-to-bots--using-captchas

/people/valery.silaev/blog/2005/09/14/a-bit-of-impractical-scripting-for-web-dynpro

Regards,

Jaya.

[Former Member]

Hi,

I am facing the same issue in Web Dynpro Java DC for Netweaver 7.3

I have added the external library DC's compilation public part to WD and enterprise application DC's assembly pp to WD but still in the runtime i get an error java.lang.ClassNotFoundException: jxl.format.CellFormat

The jxl jar is already added to the external library DC.

Please help/suggest.

Best Regards

Gaurang Dayal

[Former Member]

nice info. in future, if you are stuck trying to find out which jar contains the class you are looking for, you might want to try out this online utility:

http://www.ellipsissolutions.com/xray.php

Thanks,

GT

[Former Member]

Thank you

[Former Member]

Hi All,

The issue is resloved .It was because i was deploying the Application after deploying the DC.But the error did not occur when i only built and deployed the DC alone which internally Deploys the Application also and viewed the Preview in the Iview it was working fine.

Thanks for your help and prompt replies.

Regards,

Nishita Salver

[Former Member]

Hi,

You need to create three dcs:

sap.com/ jxldemo (WebDynpro DC)

sap.com/ llib (External library DC to add the external jar)

sap.com/ test~jars (J2EE library DC)

We can add external jars to this External Library DC. As this DC is non deployable DC we need to create two public parts. One public part is for compilation purpose (API) and another for runtime purpose (SDA deployable).

API Pubic part:. We need to add this as used dc in WebDynpro DC for design time purpose.

SDA Public part: We need to deploy this as part of some other EAR.

For deploying the SDA Public part there are two ways.

As WebDynproDC also contains an EAR we can deploy this as part of WebDynpro DC. For this we need to add this SDA public part to WebDynpro DC as used dc.

Note: If we are deploying into local server, then we should not deploy using RightClickOnDCàDeploy or RightClickApplicatonàDeploy New Archive and Run.

We should deploy using RightClickOnDC à Development Component à Deploy. If not the external jar will not be deployed into the server.

Help: /people/bala.krishnan2/blog/2006/09/25/bid-adieu-to-bots--using-captchas

2. Create J2EE Library DC which is deployable dc, now add the SDA public part of External library dc to this J2EE library dc as used dc and deploy this J2EE lib dc into the server.

Give the shared reference of this J2EE lib dc in the WebDynpro DC as u2018u2019sap.com_testjarsu201D (RightClickOnDCàPropertiesàWebDynpro ReferencesàLibrary References)

Help: /people/bertram.ganz/blog/2008/11/24/how-to-use-external-jar-files-in-web-dynpro-development-components

Jxl demo blog in sdn: /people/subramanian.venkateswaran2/blog/2006/08/16/exporting-table-data-to-ms-excel-sheetenhanced-web-dynpro-binary-cache

Regards,

Charan