从HTML页面中提取csv数据 [英] Extracting csv data from HTML page

问题描述

我对编程很陌生。我需要从这个HTML页面中提取数据：http：//www.bmreports.com/servlet/com.logica.neta.bwp_MarketIndexServlet？displayCsv = false



我需要每30分钟左右更新一次数据。因为，这个页面已经有链接提取csv中的当前数据，我希望有可能使用C＃，VB.Net或一些VB脚本在csv中捕获这些信息。



非常感谢有关如何使用任何3 C＃，VB.NET，VB脚本以CSV格式提取此信息的任何指导。



谢谢，

J

Hi,
I am quite new to programming. I need to extract the data from this HTML page: http://www.bmreports.com/servlet/com.logica.neta.bwp_MarketIndexServlet?displayCsv=false

I need to get the data updated every 30mins or so. Since, this page already has link to extract the current data in csv, i was hoping it might be possible to capture this information in csv using either C#, VB.Net or some VB Script.

Would appreciate any guidance on how I can pull this information in CSV format using any of the 3- C#, VB.NET, VB Script.

Thanks,
J

推荐答案

有几十种不同的方式......如果你看一下页面来源，你会看到CSV数据就在脚本标记中。您可以使用.NET的WebClient类下载页面，然后解析代码以提取此数据非常简单。

There are dozens of different ways... if you look at the page source there you'll see that the CSV data is right there in a script tag. You could download the page using .NET's WebClient class, then it'd be pretty straightforward to parse the code to extract this data.

这篇关于从HTML页面中提取csv数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！