How to select custom range in for each row?

[nitin.khedkar]

How do i select columns A6:to the end of sheet ?

I am trying to do this via activity “for each excel row” below is my current approach which goes through the complete excel

I have also tried using the below but it is not working and its giving me error

what i am trying to achieve?
selecting data from lets say A6:End so that execution time of for loop would be reduced

[Shiva_Nikhil]

@nitin.khedkar

can you try this once

[Nawazish_Ahmad]

Hi @nitin.khedkar

For Range A6 to End you can use .Range(“A6”) and for Specific Range you can use .Range(“A6:Z10”)
For reference you can see below images for both the condition.

**Z10 is for reference (For selecting specific range)

Hope this helps you.

Cheers!

[sai_gupta]

@nitin.khedkar

in for each row data table

try this

YourDataTable.AsEnumerable().Skip(5)

you will get the 6 th row in first place

cheers…!

[nitin.khedkar]

Hi Shiva_Nikhil it is working thank you very much for your help much appreciated!

[nitin.khedkar]

Hi Nawazish_Ahmad even this is working thank you very much for your help much appreciated!