topic Error java.lang.NoSuchMethodError: org.apache.poi.ss.usermodel.Cell.getCellType() in Talend Studio

Error java.lang.NoSuchMethodError: org.apache.poi.ss.usermodel.Cell.getCellType()

Anonymous — Sat, 16 Nov 2024 02:01:35 GMT

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

Re: Error java.lang.NoSuchMethodError: org.apache.poi.ss.usermodel.Cell.getCellType()

Anonymous — Wed, 01 Jul 2020 04:16:45 GMT

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)

Regards
Shong

Re: Error java.lang.NoSuchMethodError: org.apache.poi.ss.usermodel.Cell.getCellType()

Anonymous — Wed, 01 Jul 2020 04:16:45 GMT

Re: Error java.lang.NoSuchMethodError: org.apache.poi.ss.usermodel.Cell.getCellType()

Anonymous — Wed, 01 Jul 2020 07:45:53 GMT

Hi Shong,

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.

Studio version : 7.0.1

windows 10 - 64 bit,

jdk 8u251 (1.8.0_251)

Re: Error java.lang.NoSuchMethodError: org.apache.poi.ss.usermodel.Cell.getCellType()

Anonymous — Wed, 01 Jul 2020 07:45:53 GMT

Hi Shong,

Studio version : 7.0.1

windows 10 - 64 bit,

jdk 8u251 (1.8.0_251)

Re: Error java.lang.NoSuchMethodError: org.apache.poi.ss.usermodel.Cell.getCellType()

Anonymous — Fri, 03 Jul 2020 08:27:29 GMT

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.

Regards
Shong

Re: Error java.lang.NoSuchMethodError: org.apache.poi.ss.usermodel.Cell.getCellType()

Anonymous — Fri, 03 Jul 2020 08:27:29 GMT

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.

Regards
Shong

Re: Error java.lang.NoSuchMethodError: org.apache.poi.ss.usermodel.Cell.getCellType()

nmodi — Thu, 30 Jul 2020 20:09:47 GMT

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?

Re: Error java.lang.NoSuchMethodError: org.apache.poi.ss.usermodel.Cell.getCellType()

Anonymous — Thu, 27 Aug 2020 14:14:10 GMT

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.