Error in Excel read and write using Webdynpro table

[Former Member]

Dear Forum,<br />

<br />

I have a webdynpro local DC. I have display the values from a .xls file into a webdynpro table. I am using jxl.jar for this. <br />

I have added this jar file into the project lib folder and have added this into build path as well. But upon running the application I ma getting the error:<br />

<br />

java.lang.ClassNotFoundException: jxl.read.biff.BiffException<hr />

Loader Info<hr />

ClassLoader name: <a class="jive-link-external" href="http://demo.sap.com/taxdataflow" target="_newWindow">http://demo.sap.com/taxdataflow</a> Living status: alive Direct parent loaders: <a href="https://forums.sdn.sap.com/" target="_newWindow">system:Frame</a> <a href="https://forums.sdn.sap.com/" target="_newWindow">service:servlet_jsp</a> <a href="https://forums.sdn.sap.com/" target="_newWindow">service:ejb</a> <a class="jive-link-external" href="http://sap.com/tc_wdapi" target="_newWindow">http://sap.com/tc_wdapi</a> <a href="https://forums.sdn.sap.com/" target="_newWindow">library:tc_blexception_{lib</a> <a href="https://forums.sdn.sap.com/" target="_newWindow">library:tc}bl_loggingapi</a> Resources: D:\usr\sap\DP7\J47\j2ee\cluster\apps\demo.sap.com\taxdataflow\servlet_jsp\webdynpro\resources\demo.sap.com\taxdataflow\root\WEB-INF\lib\app.jar<hr />

<p />

at com.sap.engine.boot.loader.MultiParentClassLoader.loadClass(MultiParentClassLoader.java:259)<br />

at com.sap.engine.boot.loader.MultiParentClassLoader.loadClass(MultiParentClassLoader.java:228)<br />

at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:353)<br />

at com.sap.demo.taxdataflow.taxdataapp.comp.wdp.InternalTaxDataCompView.&lt;init&gt;(InternalTaxDataCompView.java:112)<br />

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)<br />

<br />

I have tried many ways to resolve the error but failed. <br />

Any help is appreciated.<br />

<br />

Thanks,<br />

Mickey.<br />

<br />

[Former Member]

Problem resolved.

[Former Member]

hi

check this link

export table data to excel using jxi , check the blog

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

Thanks

[Former Member]

Hi,

At runtime that jar is not available that is why you are getting this error.

If you are using noraml WebDynpro project (not DC) then adding to build path works i guess.

There are two ways of using the external jars in WebDynpro DCs.

First you need to create one external library dc then you need to add the external jar to that dc.

You need to create two public parts for this jar.

1. API (design time purpose) 2. SDA (run time purpose)

Approach1:

After this you need to add these two public parts in WebDynpro DC as Used DCs. Now you should not deploy using RightClick > Deploy/ Deploy New Archieve and Run. You should deploy using RightClick>Development Component --> Deploy. Then only it works.

See the below blog for the same:

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

Approach2:

Add the API public part to WebDynpro DC for design time purpose as Used DC. Create J2EE Lib DC and add SDA public part to this DC and deploy this J2EE Lib DC. Now give the library reference to this J2EE Lib DC in WebDynpro DC properties.

See the below blog for the same:

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

Regards,

Charan