Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Web scraping
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...o&userid=31028 View this thread: http://www.excelforum.com/showthread...hreadid=506970 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Web scraping
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...o&userid=31028 View this thread: http://www.excelforum.com/showthread...hreadid=506970 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Web scraping
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|