Extract different table and put it in to excel from website

Help
1

Hi Friends,

1.I am having a Web site, -
https://ecomm.one-line.com/ecom/CUP_HOM_3301.do
Enter the number as below
image

2.This web site has different different tables.
3. From these tables(some 5 small tables) i have to extract different fields.
ex: from table 1 - extract 2 fileds. table 2 5 fields.

image
image869×355 18 KB

And put all these in to same excel file in different columns , with column header.

Solution i tried: using web scraping, extracted one table.
Tried to extract different fields not able to get it.

NOTE: it has scrollbar i have to drag down for rest of the tables.

Regards,
Sonika

2

You have option to download as Excel in Web Page, that might help to do in a best way. Did you explore that ?

3

@sishiramishra

yes i have taken the excel from the data table - which is auto generated from the extracted table,while “data scraping”

I dont want complete table, i want only few frecords from each table…

4

After data loaded you can extract Data using LINQ queries or some statement like below

Your_Datatable.Rows(<Your_Row_index>).Item(<Your_Col_Index)

5

@sishiramishra

Can you please help me with one or 2 records from the site i gave?
Please