如何从网页上抓取数据并将其放入电子表格中 [英] how to scrape data from webpage and put it into spreadsheet

问题描述

这是网页：



http：//www.nepalidirectory。 com.au/listing.php?category=2



从我想要抓取数据并将其放入Excel电子表格。



电子表格BusinessName，Address和Phone中有三个字段。



这些信息可在网页上找到。



请告诉我如何通过VB.Net代码抓取这些数据并将其放入电子表格中。



谢谢，

Virendra

解决方案

你可以使用html解析器，如 Html Agility Pack [ ^ ]或Web应用程序测试工具，如WatiN [ ^ ]。



查看下面关于明喻上下文的codeproject文章 WebSite Scraping [ ^

Hi,

this is the webpage:

http://www.nepalidirectory.com.au/listing.php?category=2

from where I want to scrape data and put it into Excel Spreadsheet.

there is three fields in spreadsheet BusinessName, Address and Phone.

these information are available in webpage.

Please tell me how can I scrape these data and put it into spreadsheet by VB.Net Code.

Thanks,
Virendra

解决方案

you can use html parser like Html Agility Pack[^] or Web Application Testing tool like WatiN [^].

check below codeproject article about simile context WebSite Scraping[^]

这篇关于如何从网页上抓取数据并将其放入电子表格中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！