Web scraping

M

mickbarry

Morning all,
Currently have Excel2000.
Would like to scrape webpage into Excel (ALT_D_D_W) from the URL-
http://newsite.tab.co.nz/racing/
It comes back with error message "Returned no data try editin
query"
(ALT_D_D_E)
Tried editing with no joy, can anyone out there overcome thi
challenge?

Regards Mick Barry
A horse is carved from a wooden block by removing the bits that don'
look like a horse
 
A

alex_f_il

You can try SW Explorer Automation
(SWEA)http://home.comcast.net/~furmana/SWIEAutomation.htm.

The following example shows how to get a table from the
http://newsite.tab.co.nz/racing/ Web site using SWEA. SWEAProject.htp
was created by SWEA Visual Designer. SWEA designer contains Visual
Table Extractor. The Table Data Extractor extracts tabular data from
the Web pages. If a Web page contains repeating information patterns
than the data can be transformed into ADO.NET DataTable object.

public static void Main() {
SWExplorerAutomation.Client.ExplorerManager explorerManager = new
SWExplorerAutomation.Client.ExplorerManager();
SWExplorerAutomation.Client.Scene scene;
explorerManager.Connect(-1);
explorerManager.LoadProject("SWEAProject.htp");
explorerManager.Navigate("http://newsite.tab.co.nz/racing/");
scene = explorerManager["Scene_0"];
scene.WaitForActive(30000);
System.Data.DataTable dataTable;
dataTable =
((HtmlContent)(scene["HtmlContent_0"])).TableDataExtractor.DataTable;
explorerManager.DisconnectAndClose();
}

The DataTable can be stored into text file (CSV) and loaded by Excel or
Excel application can be called directly from the scraping program.
 
H

hansyt

In IE highlight the tabel you want to extract or click in the frame you
want to extract the table(s) from and hit Ctrl-A to select all. Then
hit Ctrl-C. Go to Excel and hit Ctrl-V. That will paste the table or
all tables into your worksheet. You can work with these tables like
with any other tables.

Hans
 
Top