How to copy specific number of rows from one excel sheet and paste them into another

Help Robot
,
1

HI,

I have data like this

image

I need to copy row no 3, 4 and 5 and paste it into another excel sheet how to do this

2

Hi,

Your image is not visible for me Can you please repost that image?

Thank you
Minju

3

Hi @Ishan_Shelke

Do you please let us know if you have any specific search criteria to achieve the same.

Thanks

4

Hey

check my custom activity for this, you can send each index and return it

regards

5

similar as mentioned in one of your other Topics we can use skip and take

dtNew = dtOrigin.AsEnumerable.Skip(2).Take(3).CopyToDataTable

Or as an alternate

dtNew = {2,3,4}.Select(Function (x) dtOrigin.Rows(x)).CopyToDataTable

6

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