Converting an excel file to a CSV file: error

[rdoe]

Hi,

I'm new to this, and I think I have a simple question...

I am trying to convert an excel file to csv file. When I'm running I get the error like this...

 

Exception in thread "main" java.lang.Error: Unresolved compilation problems:
    jxl cannot be resolved to a type
    jxl cannot be resolved to a type
    jxl cannot be resolved to a type
    jxl cannot be resolved
    jxl cannot be resolved to a type
    jxl cannot be resolved to a type
    jxl cannot be resolved to a type
    jxl cannot be resolved to a type
    jxl cannot be resolved to a type
    jxl cannot be resolved to a type

    at talenddemosjava.abc123_0_1.Abc123.tFileInputExcel_1Process(Abc123.java:330)
    at talenddemosjava.abc123_0_1.Abc123.runJobInTOS(Abc123.java:598)
    at talenddemosjava.abc123_0_1.Abc123.main(Abc123.java:511)
Job Abc123 ended at 11:19 21/11/2008. [exit code=1]

 

Please advise

 

Thanks,

Rendell

[stasp]

Hi,

Exception in thread "main" java.lang.Error: Unresolved compilation problems

Go to the 'code' tab, you will see the error message there.

 

Regards,

Stas

[rdoe]

Stas,

In code I'm gettin this error:

 

java.util.List<jxl.Sheet> sheetList_tFileInputExcel_1 = new java.util.ArrayList<jxl.Sheet>();
jxl.Sheet sh_tFileInputExcel_1 = null;

 

Also in designer there are messages:

-no schema difined yet and
-parameter (sheet list) must have atleast one value

 

Thanks

[stasp]

You have to define a schema for your tFileInputExcel component. You need as much columns in this schema as the number of columns you want to retrieve from the xls file.

You also have to define which sheet of your excel file you will retrieve the datas from ("Sheet List" option)

Connect the tFileInputExcel to tFileOutputDelimited and that should be ok.

You may want to read the user documentation if you need further information.

[zarfishan.biztek]

Try this Cloud API excel file to csv converter : http://www.aspose.com/java/excel-component.aspx

 

it can also convert excel file to any other format you want.