Web scraping

  • Thread starter Thread starter mickbarry
  • Start date Start date
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
 
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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top