Suppress or handle warnings "Cannot read name ranges for TableName - setting to empty"

[mobmsc2]

I have a number of

tFileInputExcel

components in a job and they are filling the console window with

Warning:  Cannot read name ranges for TableName - setting to empty

messages. Is there a way to suppress or handle this particular error in a more graceful way?

[Sid3]

hi,

Please share your job and error with a screenshot. else can you elaborate your error.

Have a look to this link. hope it helps.

https://community.talend.com/t5/Design-and-Development/resolved-Cannot-read-name-ranges-Error/td-p/6...

[mobmsc2]

That does look useful

Is there a way to suppress or handle the warning without needing to open all the Excel files?

[Sid3]

you have to resolves this at excel side. dont think Talend can do something here.

Thanks,
Sid
Please like the post if it is useful
Please put to resolved if it resolves your issue.

[cterenzi · Accepted solution]

If you are not reading xlsx files, there is a checkbox on the Advanced Settings tab of tFileInputExcel labeled "Ignore the warning" which may help.