Select Excel column

I want to select the whole Excel column with “Select range activity”.
How to do ?


Just specify the column range in Select Range activity. If it is ‘A’ column then mention it like this: "A1:A30"

If you don’t know final cell then use Read Range activity and count no. rows and store it in a integer variable say ‘count’. And then pass range like this: “A1:A”+count.Tostring

use get column activity

It works fine.

Thanks a lot guys

Hi rahatadi,

for get column activity which package i need to use.
I am not getting