Error in Excel Upload

[Former Member]

Hi,

When I try this example(upload excel in wd java) http://wiki.scn.sap.com/wiki/display/WDJava/Uploading+excel+file+using+WebDynpro+for+Java i m getting the following build errors.

     [javac] ERROR: D:\WS1.0.jdi\0\t\EE51CE12D57697FB14956F6EE59B2F38\gen_wdp\packages\java:26: package jxl does not exist
     [javac] ERROR: import jxl.Sheet;

     [javac] ERROR: D:\WS1.0.jdi\0\t\EE51CE12D57697FB14956F6EE59B2F38\gen_wdp\packages\.java:27: package jxl does not exist
     [javac] ERROR: import jxl.Workbook; 

     [javac] ERROR: D:\WS1.0.jdi\0\t\EE51CE12D57697FB14956F6EE59B2F38\gen_wdp\packages\java:293: cannot find symbol

     [javac] ERROR: symbol : class Cell

     [javac] ERROR: Cell c1 = sh.getCell(i,j);

Pls help me solve this and I found this is coz of this code.

[Former Member]

Add jxl.jar into your lib folder from resource perpective  and add the jar to your  build path.

[Sharathmg]

Its a standard issue when using external libraries and especially common with excel in WDJ.

Firstly, your compiler is not able to recognize the source of these new methods used in the method ex: jxl. So, try to add the dependency at compile time too.

You can refer my blog on the similar issue:

Regards,

Sharath

[Former Member]

Dear Sakthi,

This error comes  when your code didn't refer the required jar file at run time

You can try:

1) Add jxl.jar file into your java build path and lib folder of your application.

or

2) Check following link for creating external dc & add dependency.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/60d99678-1a29-2d10-94b4-9d9a67b71...

Thanks & Regards,

Patralekha