Start (re-start) processing Excel on Row# (Prompt User)

Hi,

If we can know number of rows to skip, the following will work.

First, read whole data with header as datatable using ReadRange activity (Let’s say dt)

Then, if we want to skip 5 rows, for example,

dt = dt.AsEnumerable.Skip(5).CopyToDataTable

Hope this helps you.

Regards,

3 Likes