How to select custom range in for each row?

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

Screenshot 2023-12-06 122015

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

@nitin.khedkar

image

can you try this once

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!

1 Like

@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…!

1 Like

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

1 Like

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

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.