cancel
Showing results for 
Search instead for 
Did you mean: 

error : export to excel

Former Member
0 Kudos

Hi,

I have a webdynpro dc where i am using the export to excel functionality.I have added jxl.jar,Jexcel.jar and Jexcel-install.jar in the libraries.As soon as i build and deploy i get an error :

java.lang.NoClassDefFoundError: jxl/write/WriteException

at com.sap.darpan.component.wdp.InternalTdc_AllocationOutputView.<init>(InternalTdc_AllocationOutputView.java:154)

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)

at java.lang.reflect.Constructor.newInstance(Constructor.java:274)

Any clues on this?

I have no code at line no InternalTdc_AllocationOutputView.java:154

Accepted Solutions (1)

Accepted Solutions (1)

lokesh_kamana
Active Contributor
0 Kudos

Hi,

As your using DC .

You have to add the jars in external library DC.

And create public part for that and should declare that DC as used DC in the DC which you are using the export to excel functionality.

Note:- create public parts of both SDA and API type.

Could you please let us know which version are you using.

Thanks & Regards,

Lokesh

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

If yours is a normal webdynpro project then add the 3rd partt tool jxl.jar ifrom the build path.

If it is DC then

Go through this thread

Regards,

Padma N

Former Member
0 Kudos

hey Padma,

Thanx for your reply but i have already added the reference of a dc which contains all these.

Any other clue?

former_member192434
Active Contributor
0 Kudos

Hi

follow this:

  • Add the Public part of the J2EE server Lib project to the project where you need to use those jars.

  • If it is a Web Dynpro project, then you need to add the name of the J2EE Server Library project to the

project Properties -> Project References -> Library References.

for more details check this

Thanks

Former Member
0 Kudos

Hi,

Go through this thread

Regards

Padma N

Former Member
0 Kudos

Hi,

It's not the problem with your DC. The error is coming because, the library is missing at server.

For this, you have to create J2EE library project ,add jxl.jar to it and deploy it in server. as follows

1: choose File->new->project->other->J2EE Server Component-->

2: select 'Library' and click on 'Next'

3: Give sample name 'JExcelLib' and click on 'Finish'

4: Now goto navigator, copy jxl.jar from your pc and paste it into your project 'JExcelLib'

5: Now goto J2EE explorer, right click on 'JExcelLib' and select 'Build Library Archive'.

6: Right click on the .sda file that is generated and select 'Deploy To J2EE Engine'

Regards

Narayana