我用WebBrowser组件编写一段获取html网页数据。分析得到的数据总是不理想。
我想分析中国农业银行里面的“理财服务 > 动态行情 > 开放式基金净值公告”表中的数据。可是得到的数据都是农业银行首页上的表格框架中的数据,没有我要的基金中的数据。5555,弄了2天了,苦痛啊!好心的兄弟姐妹们,帮帮忙啊~ QQ:113545560
先帖一下我的代码。
Private Sub Command1_Click()
WebBrowser1.Navigate "http://www.abchina.com/cn/hq/jijinjz.jsp/fid=20000020/id=120003850/sid=105000706/index.html"
End SubPrivate Sub WebBrowser1_DocumentComplete(ByVal pDisp As Object, URL As Variant)
If Not (pDisp Is WebBrowser1.Object) Then Exit Sub
'On Error Resume Next
Dim i, j As Long
Dim Text As String
Dim Row As HTMLTableRow, Cell As HTMLTableCell, Table1 As HTMLTable, Tables As IHTMLElementCollection
Set Tables = WebBrowser1.Document.getElementsByTagName("TABLE")
For Each Table1 In Tables
For i = 0 To Table1.rows.length - 1 ' 逐行处理
Set Row = Table1.rows(i)
j = 0
For Each Cell In Row.cells ' 逐列处理
'Row.cells(j).innerText即为当前行及当前列上的单元数据
Text = Text + Trim(Row.cells(j).innerText) + "," ’得到数据
j = j + 1
Next
' 一行处理完毕后,去除行尾的逗号并加上回车
Text = Left(Text, Len(Text) - 1) + vbCrLf
Next i
Next Table1
Debug.Print Text
End Sub
我想分析中国农业银行里面的“理财服务 > 动态行情 > 开放式基金净值公告”表中的数据。可是得到的数据都是农业银行首页上的表格框架中的数据,没有我要的基金中的数据。5555,弄了2天了,苦痛啊!好心的兄弟姐妹们,帮帮忙啊~ QQ:113545560
先帖一下我的代码。
Private Sub Command1_Click()
WebBrowser1.Navigate "http://www.abchina.com/cn/hq/jijinjz.jsp/fid=20000020/id=120003850/sid=105000706/index.html"
End SubPrivate Sub WebBrowser1_DocumentComplete(ByVal pDisp As Object, URL As Variant)
If Not (pDisp Is WebBrowser1.Object) Then Exit Sub
'On Error Resume Next
Dim i, j As Long
Dim Text As String
Dim Row As HTMLTableRow, Cell As HTMLTableCell, Table1 As HTMLTable, Tables As IHTMLElementCollection
Set Tables = WebBrowser1.Document.getElementsByTagName("TABLE")
For Each Table1 In Tables
For i = 0 To Table1.rows.length - 1 ' 逐行处理
Set Row = Table1.rows(i)
j = 0
For Each Cell In Row.cells ' 逐列处理
'Row.cells(j).innerText即为当前行及当前列上的单元数据
Text = Text + Trim(Row.cells(j).innerText) + "," ’得到数据
j = j + 1
Next
' 一行处理完毕后,去除行尾的逗号并加上回车
Text = Left(Text, Len(Text) - 1) + vbCrLf
Next i
Next Table1
Debug.Print Text
End Sub
解决方案 »
- usercontrol如何获取到当前所在载体中的坐标位置?
- 如何使mdi多文档界面中子窗体格式统一
- 模仿单击按钮,怎么办???
- WebBrowser控件可以不下载图片吗?
- winsock 通信一发数据到服务器就自己关掉了客户端,讨论一下--散分--散分--散分-100
- split问题
- 谁能给我一个 vb 全局 监视键盘 hook的源代码
- MY GOD!救命!
- SQL又出问题了!报错:至少一个参数没有被指定值!如果解决了,马上加分!谢谢!
- 用什么方法向组件传递批量数据比较好?
- 知道treeview某个节点的值,如何写语句使这个节点处于编辑状态,高手请进来指点。
- 本人查了很多关于如何删除临时表的文章都不能解决的问题,请高手帮忙解决!
WebBrowser1.Navigate "http://www.abchina.com/wwwroot/dynamic/cn/jijinjz.html?timeStamp"
End SubPrivate Sub WebBrowser1_DocumentComplete(ByVal pDisp As Object, URL As Variant)
If Not (pDisp Is WebBrowser1.Object) Then Exit Sub
'On Error Resume Next
Dim i, j As Long
Dim Text As String
Dim Row As HTMLTableRow, Cell As HTMLTableCell, Table1 As HTMLTable, Tables As IHTMLElementCollection
Set Tables = WebBrowser1.Document.getElementsByTagName("TABLE")
For Each Table1 In Tables
For i = 0 To Table1.rows.length - 1 ' 逐行处理
Set Row = Table1.rows(i)
j = 0
For Each Cell In Row.cells ' 逐列处理
'Row.cells(j).innerText即为当前行及当前列上的单元数据
Text = Text + Trim(Row.cells(j).innerText) + "," '得到数据
j = j + 1
Next
' 一行处理完毕后,去除行尾的逗号并加上回车
Text = Left(Text, Len(Text) - 1) + vbCrLf
Next i
Next Table1
Debug.Print Text
End Sub