Newbee Question about excel imports

3.79K viewsDataLink
0

I am in the first day of my trial period. So bear with me.
Importing data from Excel is crucial. Deal breaker.
So I named my ranges in Excel. I went to data link and chose the file and click next. Right after I go though that password thingy, I am in a position to chose columns but nowhere does it give me the option of choosing the named range.

Where do I enter the name of the range that I wish to chose?

0

Thanks again. Back to the exercise.

0

Glad that helped. If you double-click the named range itself that will grab all the columns in the data source.

0

Worked just fine. Thanks.

Just a quick followup. Is there a way other than double clicking column by column to select the columns. I regularly get massive data sheets.

0

Hi – thanks for posting.

The Excel model needs to be saved and closed prior to connecting to it via Quantrix DataLink. If it is left open there is some conflict that prevents Quantrix from seeing the named ranges.

Hope this helps!

-Mike