topic Re: tFileExcelSheetInput - java.lang.NoSuchMethodError: 'org.apache.poi.ss.usermodel.CellType org.apache.poi.ss.usermodel.Cell.getCellType()' in Installing and Upgrading

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

SHTalend — Fri, 15 Nov 2024 22:28:59 GMT

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)

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

Anonymous — Mon, 10 Oct 2022 12:50:32 GMT

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.

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

SHTalend — Tue, 11 Oct 2022 11:22:29 GMT

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)'

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

Anonymous — Tue, 11 Oct 2022 13:52:00 GMT

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

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

SHTalend — Tue, 11 Oct 2022 15:09:56 GMT

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

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

Anonymous — Tue, 11 Oct 2022 15:20:29 GMT

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?

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

SHTalend — Tue, 11 Oct 2022 18:28:13 GMT

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

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

Anonymous — Tue, 11 Oct 2022 18:30:35 GMT

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.