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?
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…
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
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