rdoe Posted July 12, 2009 Share Posted July 12, 2009 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 Link to comment Share on other sites More sharing options...
stasp Posted July 13, 2009 Share Posted July 13, 2009 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 Link to comment Share on other sites More sharing options...
rdoe Posted July 13, 2009 Author Share Posted July 13, 2009 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 Link to comment Share on other sites More sharing options...
stasp Posted July 13, 2009 Share Posted July 13, 2009 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. Link to comment Share on other sites More sharing options...
zarfishan.biztek Posted July 22, 2013 Share Posted July 22, 2013 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. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now