Parsing HTML in VB.NET

Question

I have the following problem :

I have a file on my hardisk which name is tables.html. In this file are some tables coded in HTML. I want to readout all the rows and columns of the tables. It would be possible to kill out all the <TD> and <TR> by using string (also REXX) manipulation, but i am sure that there is a better way to do it. Isnt the WEBROWSER control already parsing the whole HTML ? Isnt it possible to browse in the complex datatype the ready parsed HTML ? I dont know how ... does anyone know ? Maybe the datatypes HtmlElement or HtmlDocument can help.....

thomas oechel · Answer

Dim webBrowser1 As WebBrowser = New WebBrowser() webBrowser1.Navigate(filename) While webBrowser1.ReadyState = WebBrowserReadyState.Loading Debug.Print( "Wait" ) Application.DoEvents() End While Dim htmlelecol As HtmlElementCollection = webBrowser1.Document.GetElementsByTagName( "TABLE" ) Dim tab1 As HtmlElement = htmlelecol.Item(1) Dim zelle As String Dim tzeile As Integer = 0 Dim tspalte As Integer = 0 For tzeile = 0 To tab1.Children.Item(0).Children.Count - 1 For tspalte = 0 To tab1.Children.Item(0).Children(0).Children.Count - 1 zelle = tab1.Children.Item(0).Children(tzeile).Children(tspalte).InnerText Debug.Print(zelle) Next Next

thomas oechel · Answer

Dim xxx As HtmlElementCollection xxx = WebBrowser1.Document.GetElementsByTagName( "TABLE" ) Dim b As Integer = xxx.Count() Dim abc As HtmlElement = xxx.Item(1) TextBox1.Text = abc.OuterText something like that runs...

Parsing HTML in VB.NET

Answers (2)