Select Excel column

[Youssef]

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

[lakshman (Ganta lakshman)]

@Youssef

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

[rahatadi (Aditya Rahatekar)]

@Youssef
use get column activity

[Youssef]

It works fine.

Thanks a lot guys

[keshav (Kumar keshav)]

Hi rahatadi,

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

Thanks,
Keshav