How to read row 2-3 only?

fairymemay · June 13, 2021, 12:48pm

I want to read row 2-3 only,

My flow as below.

Please guide about it.

Srini84 · June 13, 2021, 12:55pm

Check as below

dt1.AsEnumerable.Take(Number of rows).CopyToDataTable

Like as dt1.AsEnumerable.Take(2).CopyToDataTable to get first two rows

In assign use the above expression

Hope this may help you

Thanks

So it will take

Aleem_Khan · June 13, 2021, 1:15pm

You can use read Range A2:D3 and store in data table

fairymemay · June 13, 2021, 1:16pm

@Srini84 I have ask more question.

If I want delete rows 2-3 after read.

Please guide me more.

Srini84 · June 13, 2021, 1:18pm

Instead of Take use Skip, Check below

dt1.AsEnumerable.Skip(2).CopyToDataTable

Hope this may help you

Thanks

fairymemay · June 13, 2021, 1:22pm

@Srini84 I run file by monthly (read rows 2-3 only).
So I want delete rows 2-3 because in next month I will read data from rows 2-3.

Any suggest about this case?

Srini84 · June 13, 2021, 1:25pm

So once you read the rows then delete using skip and use write range to write back to excel

may be this helps

Thanks

system · June 16, 2021, 1:25pm

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