i am getting the following errors while i am trying to run my job with custom excel components. Can anyone please help me in resolving this. I have also attached the images for error,design and component details
[statistics] connecting to socket on port 3635
[statistics] connected
Exception in thread "main" java.lang.NoSuchMethodError: org.apache.poi.ss.usermodel.Cell.getCellType()Lorg/apache/poi/ss/usermodel/CellType;
at de.jlo.talendcomp.excel.SpreadsheetFile.isRowEmpty(SpreadsheetFile.java:752)
at de.jlo.talendcomp.excel.SpreadsheetFile.detectCurrentSheetLastNoneEmptyRowIndex(SpreadsheetFile.java:740)
at hr_analytics.span_layers_v2_0_1.Span_Layers_v2.tFileInputExcel_3Process(Span_Layers_v2.java:4972)
at hr_analytics.span_layers_v2_0_1.Span_Layers_v2.tFileExcelWorkbookOpen_1Process(Span_Layers_v2.java:751)
at hr_analytics.span_layers_v2_0_1.Span_Layers_v2.runJobInTOS(Span_Layers_v2.java:5595)
at hr_analytics.span_layers_v2_0_1.Span_Layers_v2.main(Span_Layers_v2.java:5263)
Java HotSpot(TM) 64-Bit Server VM warning: ignoring option MaxPermSize=512m; support was removed in 8.0
[statistics] disconnected
[statistics] disconnected
Hi
Are you using the Excel components developed and shared by jlolling without any modification?
Please provide the following information for us to be more better evaluate the issue:
Studio version?
Operating System (such as Windows 10, 64 bit)
Java version (such as Oracle JDK build 1.8.0_201)
Hi
Are you using the Excel components developed and shared by jlolling without any modification?
Please provide the following information for us to be more better evaluate the issue:
Studio version?
Operating System (such as Windows 10, 64 bit)
Java version (such as Oracle JDK build 1.8.0_201)
Yes i am using custom components which developed by jlolling with out any modification. I have just opened the component given the path and ticked the required check boxes as in the attached screenshot.
Yes i am using custom components which developed by jlolling with out any modification. I have just opened the component given the path and ticked the required check boxes as in the attached screenshot.
Hi
The error indicates the required jar files are missing,
have you tried with the latest studio v7.3 or 7.2, I see jlolling marked the compatible studio 7.0 as retired.
Hi
The error indicates the required jar files are missing,
have you tried with the latest studio v7.3 or 7.2, I see jlolling marked the compatible studio 7.0 as retired.
we are having same issue with accessing custom component developed by J.Lolling, we are using custom excel component along with talend standard tfileexcelinput in our job
it was working fine with talend 6.4.1 enterprise version however we migrated to 7.2.1 enterprise version now & since then we are getting this issue. any idea on the solution?
I am getting this issue after upgrading from 7.1 to 7.2 of Studio.
I am using the standard built-in tFileInputExcel component and getting the error
Exception in thread "main" java.lang.NoSuchMethodError: org.apache.poi.ss.usermodel.Cell.getCellType()Lorg/apache/poi/ss/usermodel/CellType;
The issue has been introduced by Talend in the upgrade, as this was working perfectly ok until I upgraded.
I changed my job to use the tFileExcel custom components instead ( tFileExcelWorkbookOpen and tfileExcelSheetInput ) and now the jobs works perfectly fine.
