Parse table with HtmlAgilitypack issue

asp.net c# html html-agility-pack

Question

I am trying to parse a table that looks like this: 

<table><tbody>
<tr><th a href=""></th><th></th></tr>
<tr><td class="v"></td><td class="d"></td><td class="h"></td><td class="a">   </td><td class="o"></td><td class="o"></td><td class="o"></td><td class="p"><table class="p" title="ttt"></table></td></tr>
<tr><td class="v"></td><td class="d"></td><td class="h"></td><td class="a">   </td><td class="o"></td><td class="o"></td><td class="o"></td><td class="p"><table class="p" title="eee"></table></td></tr>
<tr><td class="v"></td><td class="d"></td><td class="h"></td><td class="a">   </td><td class="o"></td><td class="o"></td><td class="o"></td><td class="p"><table class="p" title="rtr"></table></td></tr>
<tr><th a href=""></th><th></th></tr>
<tr><td class="v"></td><td class="d"></td><td class="h"></td><td class="a">   </td><td class="o"></td><td class="o"></td><td class="o"></td><td class="p"><table class="p" title="ouu"></table></td></tr>
<tr><td class="v"></td><td class="d"></td><td class="h"></td><td class="a">   </td><td class="o"></td><td class="o"></td><td class="o"></td><td class="p"><table class="p" title="teee"></table></td></tr>
</tbody></table>

And I am using this code in ASP.net to get the cells in each row I want:

var getHtmlWeb = new HtmlWeb();
var document = getHtmlWeb.Load(txtbox.Text); 
//get tables
foreach (HtmlNode table in document.DocumentNode.SelectNodes("//table"))
        {
            //get each table row
            foreach (HtmlNode row in table.SelectNodes("tr"))
            {

                Outputlabel.Text += "row: <br />";
//get table head tags that have a link, get the Inner text
                if((row.SelectSingleNode("//th//a").InnerText) != null)
                {

                    Outputlabel.Text += row.SelectSingleNode("//th//a").InnerText + "<br />";
                }
                // get the cells with the classes I want
                    string d = row.SelectSingleNode("//td[@class='d']").InnerText;
                    Outputlabel.Text += row.SelectSingleNode("//td[@class='d']").InnerText + " ";

                    string h = row.SelectSingleNode("//td[@class='h']").InnerText;
                    Outputlabel.Text += row.SelectSingleNode("//td[@class='h']").InnerText + " ";
                    string a = row.SelectSingleNode("//td[@class='a']").InnerText;
                    Outputlabel.Text += row.SelectSingleNode("//td[@class='a']").InnerText + " ";
                    string op = "";
//there are 3 classes in each row to have the class="o"
                    if (row.SelectNodes("//td[@class='o']") != null)
                    {
                        foreach (HtmlNode o in row.SelectNodes("//td[@class='o']"))
                        {
                            op += o.InnerText;
                        }
                        Outputlabel.Text += op + " ";
                    }

                    var pr = row.SelectSingleNode("//td//table[@class='p']");
                    string pr = probability.Attributes["title"].Value;

                    Outputlabel.Text += pr + "<br />";
            }
        }

I get the first line of the first table only and it is repeated many times...and I do not get the class "o" and the title of the table with class "p" in the td tag with class "p"

1
2
2/1/2015 11:08:13 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

It seems to work this way for the online html file:

    HtmlWeb getHtmlWeb = new HtmlWeb();

        HtmlDocument doc = getHtmlWeb.Load(txtbox.Text);

        string d = "//td[@class='d']";
        string h = "//td[@class='h']";
        string a = "//td[@class='a']";
        string p = "//table[@class='p']";


        HtmlNodeCollection ds = doc.DocumentNode.SelectNodes(d);
        HtmlNodeCollection hs = doc.DocumentNode.SelectNodes(h);
        HtmlNodeCollection as = doc.DocumentNode.SelectNodes(a);
        HtmlNodeCollection ps = doc.DocumentNode.SelectNodes(p);
foreach (HtmlNode n in ds)
        {
            Outputlabel.Text += n.InnerHtml + "<br />"; 
        }

        foreach (HtmlNode h in hs)
        {
            Outputlabel.Text += h.InnerHtml + "<br />";
        }
        foreach (HtmlNode a in as)
        {
            Outputlabel.Text += a.Attributes["href"].Value + "<br />";
        }
        foreach (HtmlNode p in ps)
        {
            Outputlabel.Text += p.Attributes["title"].Value + "<br />";
        }
0
2/2/2015 4:12:22 PM

Related Questions

Issue with HTMLAgilityPack parsing HTML using C#

Since the data comes from javascript you have to parse the javascript and not the html, so the Agility Pack doesn't help that much, but it makes things a bit easier. The following is how it could be done using Agility Pack and ...Newtonsoft JSON.Net... to parse the Javascript....HtmlDocument htmlDoc = new HtmlDocument(); htmlDoc.Load(new WebClient(...
c# html-agility-pack xpath
asked by shriek

Parsing htmlagilitypack (table without id's) vb.net

Hope to get some answers from you. ...I use vb.net and htmlagilitypack to fetch data and it works, but not the way I want it to =)...I have this html page (part of):...<TABLE WITH=100% BORDER=4> <TR> <TH><A HREF="http:/cgi-bin/vplata.py?tgnr=4300&val=Visa+T%C3%A5gnummer&Bek=Visa&sort=Lok" >Lok</A></TH> <TH><A HREF="http:/cgi-bin/vplata.py?tgnr=430...
html html-agility-pack html-table vb.net xpath
asked by Gabriel.Linden

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

Issue parsing html using powershell and xpath

I'm way too late but here's your mistake. You've been using absolute paths....ForEach ($item in $results) { # This is working $ID = $item.GetAttributeValue("data-pid", "") # This is looping over the same item $Date = $item.SelectSingleNode("//span[@class='date']").InnerText # This is looping over the different items (i.e. thi...
html html-agility-pack html-parsing powershell xpath
asked by Tomalak

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

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

Parse HTML table with HtmlAgilityPack?

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...
html-agility-pack vb.net
asked by Lucas

htmlAgilityPack parse table to datatable or array

I have these tables:...<table> <tbody> <tr><th>Header 1</th></tr> </tbody> </table> <table> <tbody> <tr> <th>Header 1</th> <th>Header 2</th> <th>Header 3</th> <th>Header 4</th> <th>Header 5</th> </tr> <tr> <td>text 1</td> <td>text 2</td> <td>text 3</td> <td>text 4</td> <td>text 5</td> </tr> </tbody> </table> ...I am trying to transform into an arr...
c# html-agility-pack linq
asked by Rodrigo

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

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