java.lang.NullPointerException error in a tFileInputExcel

[fabienb1]

Hello everyone,

I am facing an error while using the tFileInputExcel component : if I open a specific Excel file it generates a java.lang.NullPointerException error.

If I open that Excel file, click on one random cell, save it without changing anything, then the job will run with no error.

If I open another Excel file, I do not face that error either.

I don't know what could be the cause of the problem. Is there a way to make a small change in the Excel file, for example with a tJava component, to work around the problem ?

[fabienb1]

I am sorry, it is not possible. The file contains customer data that can't be shared out of my company

[jlolling]

What about the logs from the studio?

[fabienb1]

Hi jlolling, thanks for your answer.

How do you get the java stack trace ? I have tried to run this job in debug mode. I am not sure what I am expected to find : I got the error

Plugin execution not covered by lifecycle configuration: org.talend.ci:builder-maven-plugin:8.0.12:generate

I am not sure if this could help

[fabienb1]

Hi Sabrina,

I cannot share the Excel file as it contains customer data that can't be shared out of my company.

It has one worksheet, columns go to "AK", and lines to 88000. Strings, numbers, dates... Nothing particular.

[fabienb1 · Accepted solution]

I have found the solution : I was working with a tFileInputExcel from a previous version of Talend, which behaved differently.

There was no indication on that. The only thing was a small visual difference.

I found this by comparing both components and re-mapping every column.