Extract Datable from webpage to excel

Unable to extract Datatable from webpage to excel where there is scroll bar between table header and body .Please provide help how we can extract.tried with Data scraping activity but column headers are not getting extracted

Can you show the website as example?

Hi moenk, Please find attached image.

Well I thought of an URL, a picture does not really help.

Did u faced any error while datatscrapping it ?

No , when I try to extract data from this table it does not extract column headers…only scrollbar is getting displayed.

No I do not see error…but due to scroll bar in middle complete datatable is not getting extracted.when I try to extract table body and header separately …table body gets extracted completely but table header shows scrollbar…

Hi @Aarthi_Kumar

Can u extract complete table ?

Did u tried that

Yes I tried…but could not extract…it shows only scrollbar…which in between table header and body

So try in normal way of datascraping.

Like select a cell value and then name the column with a name like that

Instead of extracting while as a datatable

In that case then I need to manually name column headers right…is there no other way to extract column headers…

Or instead of manually writing the headers u can use the datatscrapping to scrape the headers seperately and write in to the excel file and then again datascrape the webtable part and append it to the same excel file using the append datatable activitiy.

Hope it helps you


Nived N :robot:

Happy Automation :relaxed::relaxed::relaxed:

That’s were it does not works…when I try to scrap headers I shows only the scrollbar which is below header.it does not show header rows.

Then I think u have to manually add the headers and append the datatable to Excel file