tFileExcelSheetInput - java.lang.NoSuchMethodError: 'org.apache.poi.ss.usermodel.CellType org.apache.poi.ss.usermodel.Cell.getCellType()'

[SHTalend]

I have just upgraded to Java11 & TalendDI8.0.1, I'm using tFileExcelSheetInput component, but when built and ran, its now erroring. Can anyone help?

Exception in thread "main" java.lang.NoSuchMethodError: 'org.apache.poi.ss.usermodel.CellType org.apache.poi.ss.usermodel.Cell.getCellType()'

       at de.jlo.talendcomp.excel.SpreadsheetInput.isCellValueEmpty(SpreadsheetInput.java:330)

       at de.jlo.talendcomp.excel.SpreadsheetInput.isCellValueEmpty(SpreadsheetInput.java:323)

       at stdtalendt119.fil_010_validate_0_1.FIL_010_Validate_$1Helper_tFileExcelSheetInput_1.hasCurrentRowValues(FIL_010_Validate_.java:8755)

[Anonymous]

This is a component written by an external developer. He's pretty good. I have just checked Talend Exchange and have noticed that he has created an update for Talend v8. I suspect that you will need to take the update.

[SHTalend]

Yesterday I posted that I was having issues with tFileExcelSheetInput. I am now having a similar issue with the standard component tFileInputExcel.

Exception in thread "main" java.lang.NoSuchMethodError: 'org.apache.poi.ss.usermodel.Workbook org.apache.poi.ss.usermodel.WorkbookFactory.create(java.io.File, java.lang.String, boolean)'

[Anonymous]

Can you show us a screenshot of your component's configuration please?

[SHTalend]

Hi, I am now looking at the code where the line is in error. Please note before the Talend & Java upgrade this was working. Here are the details

Starting job FCT_010_PostingDate_Copy_Copy at 15:58 11/10/2022.

[statistics] connecting to socket on port 3892

[statistics] connected

Exception in thread "main" java.lang.NoSuchMethodError: 'org.apache.poi.ss.usermodel.Workbook org.apache.poi.ss.usermodel.WorkbookFactory.create(java.io.File, java.lang.String, boolean)'

[statistics] disconnected

at stdtalendt119.fct_010_postingdate_copy_copy_0_1.FCT_010_PostingDate_Copy_Copy.tFixedFlowInput_1Process(FCT_010_PostingDate_Copy_Copy.java:4980)

at stdtalendt119.fct_010_postingdate_copy_copy_0_1.FCT_010_PostingDate_Copy_Copy.runJobInTOS(FCT_010_PostingDate_Copy_Copy.java:17121)

at stdtalendt119.fct_010_postingdate_copy_copy_0_1.FCT_010_PostingDate_Copy_Copy.main(FCT_010_PostingDate_Copy_Copy.java:16568)

Job FCT_010_PostingDate_Copy_Copy ended at 15:58 11/10/2022. [Exit code = 1]

Code view:-

 

Component's configuration

[Anonymous]

This could be caused by a Jar conflict. I have just had a look regarding this and it has been shown to be a problem when the standard Excel components have been used in the same job as external Excel components. Can you try and remove all non-standard Excel components, save the job, close it and load it again?

[SHTalend]

Resolved - The job wasn't using tFileExcelSheetInput, but was using another routine that used org.apache.poi. I have now removed this routine, and the job with tFileInputExcel now runs. Thanks

[Anonymous]

Not a problem. Glad you have it sorted. You *may* be able to get the routine back IF you can use the same version of the Jar as the Jar used by the tFileInputExcel. This may not work with your routine, but more often than not you can get away with doing this.