Prev: holiday planner
Next: intercept graph vs. function
From: mickbarry on 31 Jan 2006 17:02

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 editing
query"
(ALT_D_D_E)
Tried editing with no joy, can anyone out there overcome this
challenge?

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


--
mickbarry
------------------------------------------------------------------------
mickbarry's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=31028
View this thread: http://www.excelforum.com/showthread.php?threadid=506970

From: alex_f_il on 31 Jan 2006 22:02
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.


mickbarry wrote:
> 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 editing
> query"
> (ALT_D_D_E)
> Tried editing with no joy, can anyone out there overcome this
> challenge?
>
> Regards Mick Barry
> A horse is carved from a wooden block by removing the bits that don't
> look like a horse.
>
>
> --
> mickbarry
> ------------------------------------------------------------------------
> mickbarry's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=31028
> View this thread: http://www.excelforum.com/showthread.php?threadid=506970

From: hansyt on 1 Feb 2006 05:20
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

 | 
Pages: 1
Prev: holiday planner
Next: intercept graph vs. function