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

Highlighted
Seven 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?


Accepted Solutions
Ten 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.


All Replies
Seven 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
Thanks,
Sid
Mark as solution if this resolved your issue
Seven 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?

Seven 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.
Thanks,
Sid
Mark as solution if this resolved your issue
Ten 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.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog