Six Stars

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

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?

  • Data Integration
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Nine Stars

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

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.

4 REPLIES
Six Stars

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

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://www.talendforge.org/forum/viewtopic.php?id=23560
Six Stars

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

That does look useful

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

Six Stars

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

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.
Highlighted
Nine Stars

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

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.