How to copy 10 rows from one column?

I have excel which contains 18 rows in one column named “Document Number” i need to copy only 5 rows in this column and paste into application?
Screenshot 2021-02-26 124811
During second run i will do the same with remaining rows?
Thanks in Advance?

Is it only first 5 rows? or any specific sunch

Try with linq once you read it as dt

(from x in dt select x).Take(5).CopyToDataTable

Use Skip(5)in the second run

Yes only 5 rows in first run during second run remaining rows

"Try with linq once you read it as dt

(from x in dt select x).Take(5).CopyToDataTable

Use Skip(5)in the second run"

Where i can put this?

After the first Linq query it is taken as dt. Either write it in ur required application using for each row. Post this go for 2nd query.

OR
U can take this as array/list write to notepad. or use for each to paste in ur req application

Assign Activity
dt_query=(from x in dt select x).Take(5).CopyToDataTable

@rsr.chandu
have a look here:

1 Like

@rsr.chandu if this solved Kindly close this by marking solution. If u need help let me know

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