Data scrapping adding 2 extra rows at the top before heading. How to remove those lines

Help Studio
, ,
1

Hi,
I am trying to scrap data from web page (Structured data) using data scrapping, its adding two more rows above header row. I want to remove these rows from data table. Can someone help me to do that??

for reference i am adding screenshot of data table after scrapping.

Data scrapping_LI
Data scrapping_LI633×598 48.9 KB

2

Hi @197545

Try the below expression!

ExtractDatatable.AsEnumerable.Skip(1).CopyTodatatable

Regards

3

image
image705×30 1.94 KB

It is removing Total Grants: Row, but first row is still there

4

Hi @197545

Try removing add headers properties in write range!

If you going to write in excel then try removing the add headers properties and write ,I think you re viewing by OutputDatatable!

Regards

5

@pravin_calvin
Thanks for your Help. It works, but is there any other option to remove headers.
actually i am using data scrapping in loop. I don’t want to create sheet for each loop.

Regards

6

Hi @197545

I think you need to write range and again read range to remove headers with add headers property unchecked.

Bit Lengthy method!

Regards

7

Hi @197545

And Also check with the reference thread below!

Regards