Parse HTML table with HtmlAgilityPack?

html-agility-pack vb.net

Question

I'm tearing my hair out trying to figure out this HTML agility pack business. No examples I can find work with my table not matter what I modify. Here's the table I'm working with:

<td class="trow1"><strong><a href="NEED1"><span style="color:#383838">NEED2</span></a></strong></td>
<td class="trow1">NEED3</td>
<td class="trow1" align="center"" alt="" /></td>
<td class="trow1" align="center"><strong>NEED4</strong></td>
</tr><tr>
<td class="trow2"><strong><a href="NEED1"><span class="group9">NEED2</span></a></strong></td>
<td class="trow2">NEED3</td>
<td class="trow2" align="center"" alt="" /></td>
<td class="trow2" align="center"><strong>NEED4</strong></td>
</tr><tr>
<td class="trow1"><strong><a href="NEED1"><span class="group0">NEED2</span></a></strong></td>
<td class="trow1">NEED3</td>
<td class="trow1" align="center"" alt="" /></td>
<td class="trow1" align="center"><strong>NEED4</strong></td>
</tr><tr>
<td class="trow2"><strong><a href="NEED1"><span class="group7">NEED2</span></a></strong></td>
<td class="trow2">NEED3</td>
<td class="trow2" align="center"" alt="" /></td>
<td class="trow2" align="center"><strong>NEED4</strong></td>
</tr><tr>
<td class="trow1"><strong><a href="NEED1"><span class="group0">NEED2</span></a></strong></td>
<td class="trow1">NEED3</td>
<td class="trow1" align="center"" alt="" /></td>
<td class="trow1" align="center"><strong>NEED4</strong></td>
</tr>

I've replaced what I need with "NEED"1->4 for each row. I'm looking to populate a list view with this (already made this part). But I'm lost on how to go about this.

Any help? Thank you.

1
0
3/6/2015 12:11:53 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

Translating this code to VB.NET it's not difficult, you can do it the following :

var doc = new HtmlAgilityPack.HtmlDocument();
doc.LoadHtml(html);

  • NEED1 

    var value = doc.DocumentNode.SelectSingleNode("//td[@class='trow1']/strong/a").Attributes["href"].Value;

  • NEED2

    var value = doc.DocumentNode.SelectSingleNode("//td[@class='trow1']/strong/a/span").InnerText;

  • NEED3

    var innerText = doc.DocumentNode.SelectSingleNode("//td[@class='trow1' and not(*)]").InnerText;

  • NEED4

    var innerText = doc.DocumentNode.SelectSingleNode("//td[@class='trow1']/strong[not(a)]").InnerText;

    I put above the single selection , if you want to select all the node in one you can use the method SelectNodes.

I hope this help you.

0
3/6/2015 1:14:51 AM

Related Questions

HTMLAGILITYPACK parsing and loading into a datatable in C#

I have HTML that looks like this:...<body class="style_0"> <div> <div class="style_1">Pending Test List</div> <table style=" width: 100%;" id="AUTOGENBOOKMARK_4365445353431356880"> <col> <col> <tbody> <tr> <td style="vertical-...
c# html html-agility-pack
asked by l--''''''---------''''''''''''

LINQ and HTML Agility Pack filling the parsed HTML table data into a datatable

I am using the following query to parse html table data....Dim q = From table In htmldoc.DocumentNode.SelectNodes("//table[@class='Seller']").Cast(Of HtmlNode)() From row In table.SelectNodes("tr").Cast(Of HtmlNode)() From header In row.SelectNodes("th").Cast(Of HtmlNode)() From cell In ro...
datatable html-agility-pack linq vb.net
asked by user1570048

Parse html table using LINQ and HtmlAgilityPack

I want to parse date, link text and link href from ...table class='nice'... on web page ...http://cslh.cz/delegace.html?id_season=2013...I have created object ...DelegationLink...public class DelegationLink { public string date { get; set; } public string link { get; set; } public string anchor { get; set; } } ...and used it with LINQ to c...
c# html-agility-pack linq
asked by MartinS

Parse HTML Table using HTML Agility Pack - No ID's for Table

Here is my Html Code...<center> <table cellspacing="0" cellpadding="0" border="0"> <tbody><tr><td><img src="/someimages/images/dot_t.gif" hspace="20"></td> <td><font face="Arial Rounded MT Bold, Arial, Helvetica" size="5" color="#000088"> Marks Sheet Page</font></td> </tr> </tbody></table> <table> <tbody><tr> <...
c# html-agility-pack
asked by CoolArchTek

Use HtmlAgilityPack to parse HTML variable, not HTML document?

You can use the ...LoadHtml... method of ...HtmlDocument... class
c# html-agility-pack
asked by Yuriy Rozhovetskiy

HTMLAgilityPack parse table within another table cell

I have the following table:...<table> <tr><th>header1</th><th>header2</th><th>header3</th></tr> <tr><td>value01</td><td>value02</td><td>value03</td></tr> <tr><td>value11</td><td>value12</td><td>value13</td></tr> <tr> <td colspan="3"> <table> <tr><td>subvalue01</td><td>subvalue02</td></tr> ...
arraylist c# html-agility-pack
asked by firefalcon

Remove all classes and ids from parsed HTML with HtmlAgilityPack

I use ...HtmlAgilityPack... for parsing some html page, I extract html tags from this page like this:...HtmlNode bodyContent = document.DocumentNode.SelectSingleNode("//body"); var all_text = bodyContent.SelectNodes("//div | //ul | //p | //table"); ...in returned html each tag contain class and id, I want to remove all id-s and all class how I can ...
c# html html-agility-pack
asked by Alex

Not able to parse html Table in C# using HtmlAgilityPack

I want to read the table shown in ...this link.... ...When I tried to do with ...HtmlAgilityPack..., I am getting ...null...var nodes = document.DocumentNode.SelectNodes("//table[contains(@class, 'table')]"); ...Can you please let me know what is the issue ? Am I doing it in wrong way?
c# html-agility-pack
asked by Prashanth

Parsing html using HtmlAgilityPack in C# for a cross-platform Xamarin app

I am trying to parse an online calendar to have the events posted on that calendar display in my cross-platform app. This is the code that I have so far.... var html = @"http://html-agility-pack.net/"; HtmlWeb web = new HtmlWeb(); HtmlDocument htmldoc = new HtmlAgilityPack.HtmlDocument(); var htmlDoc = web.LoadFromWebAsync(html); HtmlNodeCollec...
c# html-agility-pack xamarin
asked by Yantiss

Parse html table using HtmlAgilityPack (Linq)

Here's the table structure:...<table class="tb-stock tb-option"> <tr> <th class="bgc2">col1</th> <th class="bgc2">col2</th> <th class="bgc2">col3</th> </tr> <tr class="alt-row"> <th class="">2018/1/29</th> <td class="">0.11</td> <td class=" b-b">0.50</td> </tr> <tr class="alt-row"> <th class="">2018/1/30</th> <td cla...
html-agility-pack html-table linq
asked by user1371541

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow