Skip to Content
avatar image
Former Member

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

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_devdc_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:tcsecssl 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/tcwddispwda sap.com/tcwdcorecomp service:webdynpro service:webservices service:tcsecwssecservice service:sld library:com.sap.aii.util.xml library:jnet library:com.sap.aii.proxy.framework library:tccmi library:com.sap.aii.util.misc library:com.sap.aii.util.rb library:tcgraphicsigs library:com.sap.util.monitor.jarm library:tcddicddicruntime library:com.sap.mw.jco library:core_lib library:com.sap.lcr.api.cimclient library:sapxmltoolkit library:tcddicddicservices Resources: /usr/sap/EPD/JC00/j2ee/cluster/server0/apps/axis/portal_devdc_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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Best Answer
    avatar image
    Former Member
    Jul 06, 2009 at 11:06 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 06, 2009 at 11:20 AM

    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.comtestjarsu201D (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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 16, 2009 at 04:43 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 16, 2009 at 04:45 AM

    Thank you

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 01, 2009 at 06:23 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 31, 2013 at 03:18 PM

    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

    Add comment
    10|10000 characters needed characters exceeded