Converting an excel file to a CSV file: error

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

rdoe's picture
74
Joined: Jul 12 2009 - 2:53pm
Last seen: 14 years 2 months ago

3 Answers:

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

stasp's picture
40398
Joined: Jun 3 2009 - 9:53am
Last seen: 5 days 2 hours ago

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

rdoe's picture
74
Joined: Jul 12 2009 - 2:53pm
Last seen: 14 years 2 months ago

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.

stasp's picture
40398
Joined: Jun 3 2009 - 9:53am
Last seen: 5 days 2 hours ago

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.

zarfishan.biztek - 10 years 2 months ago
Feedback