topic Re: [resolved] Cannot read name ranges Error in Talend Studio

[resolved] Cannot read name ranges Error

JimmyM — Fri, 27 Apr 2012 20:33:19 GMT

I'm using Talend Enterprise Data Integration Team edition v5.0.2.
I have a few jobs that have SQLServer, Excel Spreadsheet, and MS Access inputs as well as Oracle and Excel outputs.
I'm getting the below error, but can't seem to track down its source. The job appears to run as expected.
Warning: Cannot read name ranges for _FilterDatabase - setting to empty
What might typically cause something like this so I can start looking in the right place at least.

Re: [resolved] Cannot read name ranges Error

Anonymous — Fri, 27 Apr 2012 21:04:20 GMT

I think the most likely candidate is Excel. If you open the workbook and hit Ctrl + F3 you should see a list of named ranges. They me be used somewhere else in the workbook, either in formulas or charts.

Re: [resolved] Cannot read name ranges Error

Anonymous — Mon, 11 Jun 2012 14:48:46 GMT

workbook?

Re: [resolved] Cannot read name ranges Error

Anonymous — Wed, 20 Jun 2012 21:38:56 GMT

I have the same problem with extra name ranges. However, I need these named ranges for my spreadsheet to function properly. So, is there a way to suppress these warnings?

Re: [resolved] Cannot read name ranges Error

_AnonymousUser — Wed, 15 Oct 2014 20:10:30 GMT

workbook?

Open de excel file and pres ctrl+F3

Re: [resolved] Cannot read name ranges Error

_AnonymousUser — Tue, 01 Sep 2015 14:59:47 GMT

It worked for me ! thanks