Import to Excel

[Former Member]

Hi all,

I want to create webdynpro java project which is related with excel import.I add jxl.jar but I get this error.

Compiling 14 source files to E:\workspace2.jdi\LocalDevelopment\t\7291808ABA1012849B71FEA00423400F\classes

     [javac] Reading options and classpath from file E:\workspace2.jdi\LocalDevelopment\t2\7291808ABA1012849B71FEA00423400F\default\logs\options2789735154914334193.tmp

     [javac] Reading list of classes to be compiled from file E:\workspace2.jdi\LocalDevelopment\t2\7291808ABA1012849B71FEA00423400F\default\logs\classes4665252903866205537.tmp

     [javac] ERROR: E:\workspace2.jdi\LocalDevelopment\t\7291808ABA1012849B71FEA00423400F\gen_wdp\packages\com\sap\demo\connect_to_database\wd\comp\connect_database\Connect_databaseView.java:27: package jxl does not exist

     [javac] ERROR: import jxl.Cell;

     [javac] ERROR:           ^

     [javac] ERROR: E:\workspace2.jdi\LocalDevelopment\t\7291808ABA1012849B71FEA00423400F\gen_wdp\packages\com\sap\demo\connect_to_database\wd\comp\connect_database\Connect_databaseView.java:28: package jxl does not exist

     [javac] ERROR: import jxl.Sheet;

     [javac] ERROR:           ^

     [javac] ERROR: E:\workspace2.jdi\LocalDevelopment\t\7291808ABA1012849B71FEA00423400F\gen_wdp\packages\com\sap\demo\connect_to_database\wd\comp\connect_database\Connect_databaseView.java:29: package jxl does not exist

     [javac] ERROR: import jxl.Workbook;

     [javac] ERROR:           ^

     [javac] ERROR: E:\workspace2.jdi\LocalDevelopment\t\7291808ABA1012849B71FEA00423400F\gen_wdp\packages\com\sap\demo\connect_to_database\wd\comp\connect_database\Connect_databaseView.java:30: package jxl.read.biff does not exist

     [javac] ERROR: import jxl.read.biff.BiffException;

     [javac] ERROR:                     ^

     [javac] ERROR: E:\workspace2.jdi\LocalDevelopment\t\7291808ABA1012849B71FEA00423400F\gen_wdp\packages\com\sap\demo\connect_to_database\wd\comp\connect_database\Connect_databaseView.java:289: cannot find symbol

     [javac] ERROR: symbol  : class Workbook

     [javac] ERROR: location: class com.sap.demo.connect_to_database.wd.comp.connect_database.Connect_databaseView

     [javac] ERROR: Workbook wb = Workbook.getWorkbook(new File("C:/Users/yalcin.gurlek/Desktop/ornek"));

     [javac] ERROR: ^

     [javac] ERROR: E:\workspace2.jdi\LocalDevelopment\t\7291808ABA1012849B71FEA00423400F\gen_wdp\packages\com\sap\demo\connect_to_database\wd\comp\connect_database\Connect_databaseView.java:289: cannot find symbol

     [javac] ERROR: symbol  : variable Workbook

     [javac] ERROR: location: class com.sap.demo.connect_to_database.wd.comp.connect_database.Connect_databaseView

     [javac] ERROR: Workbook wb = Workbook.getWorkbook(new File("C:/Users/yalcin.gurlek/Desktop/ornek"));

     [javac] ERROR:              ^

     [javac] ERROR: E:\workspace2.jdi\LocalDevelopment\t\7291808ABA1012849B71FEA00423400F\gen_wdp\packages\com\sap\demo\connect_to_database\wd\comp\connect_database\Connect_databaseView.java:290: cannot find symbol

     [javac] ERROR: symbol  : class Sheet

     [javac] ERROR: location: class com.sap.demo.connect_to_database.wd.comp.connect_database.Connect_databaseView

     [javac] ERROR: Sheet sh = wb.getSheet(0);

     [javac] ERROR: ^

     [javac] ERROR: E:\workspace2.jdi\LocalDevelopment\t\7291808ABA1012849B71FEA00423400F\gen_wdp\packages\com\sap\demo\connect_to_database\wd\comp\connect_database\Connect_databaseView.java:295: cannot find symbol

     [javac] ERROR: symbol  : class Cell

     [javac] ERROR: location: class com.sap.demo.connect_to_database.wd.comp.connect_database.Connect_databaseView

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

     [javac] ERROR: ^

     [javac] ERROR: E:\workspace2.jdi\LocalDevelopment\t\7291808ABA1012849B71FEA00423400F\gen_wdp\packages\com\sap\demo\connect_to_database\wd\comp\connect_database\Connect_databaseView.java:297: cannot find symbol

     [javac] ERROR: symbol  : class Cell

     [javac] ERROR: location: class com.sap.demo.connect_to_database.wd.comp.connect_database.Connect_databaseView

     [javac] ERROR: Cell c2 = sh.getCell(1, j);

     [javac] ERROR: ^

     [javac] ERROR: E:\workspace2.jdi\LocalDevelopment\t\7291808ABA1012849B71FEA00423400F\gen_wdp\packages\com\sap\demo\connect_to_database\wd\comp\connect_database\Connect_databaseView.java:302: cannot find symbol

     [javac] ERROR: symbol  : class BiffException

     [javac] ERROR: location: class com.sap.demo.connect_to_database.wd.comp.connect_database.Connect_databaseView

     [javac] ERROR: } catch (BiffException e) {

     [javac] ERROR:         ^

     [javac] 10 errors

Thanks your replay,

Best Regards,

Yalçın

[Former Member · Accepted solution]

Hi Yalcin,

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

[Former Member]

Thanks for your reply,

Problem solved

[Former Member]

Welcome...:)

[junwu]

search in scn regarding how to use external lib

[pradeep_kumar5]

Hi Yalcin,

you got this error because the DC build failed. Please have a look if you have missed adding the dependencies. Create one external library dc and add jar to it. create public parts for that library dc and add dependency of those public parts to your DC. It will resolve the issue.

Instead of jxl.jar I would recommend apache POI jar files for excel functionality. It offers wide range of functionality.

Regards,

Pradeep