Importing first/last row and last column from excel file.

[wonka1234]

Hi all,

How can I dynamically select the cells between Series and before Total  (A9:A89) ? 

Also how can I select last column? Ie A9 : LastColumn89? which would be A9 : Y89

[oly]

Hi @wonka1234 ,

always couple ways to do it, see example attached. If you need to keep the Series row modify and remove row-1 in the first part of the formula and later use dynamic rename to set column names correctly.

[wonka1234]

@oly 

Getting a parse error at char (4)  Unknown variable "Row-1:   1*   "

[oly]

You will need to replace my column names like 1*  with your columns - presumably A, B, C. See what columns you see as in the configuration of the Multi Row tool after you import your data file.

[wonka1234]

@oly 

you mean something like this ? or do all my columns have go in in here?

[oly]

You are correct, just the "SERIES" column should work! Make sure it's exact spelling and you can double click on your column by expanding Row-1 in "Variables" options and others. Currently I believe it's just a variable spelling typo that the tool doesn't like. Also, make sure there's no iddle spaces in the variable name. Again, easiest way it to double click on your columns.

[wonka1234]

@oly 

Still have some issues here, getting all 0's in my select column!