Html Agility Pack - loop through rows and columns

c# html-agility-pack

Question

I am just getting involved on parsing some html files using C# language and HtmlAgilityPack.

I am trying to get for each row the two columns values to insert them into a database. But running the following:

foreach (HtmlNode row in htmlDoc.DocumentNode.SelectNodes("//tr"))
    {
    foreach (HtmlNode cell in row.SelectNodes("//td"))
    {
    Console.WriteLine(cell.InnerText);
    }
    }

I got an error as I loop over all the td and not only the ones includes in the current tr.

My html looks like this:

<table>
        <tr>            
            <th align="center" width="50"><b>column 1</b></th>          
            <th align="center" width="210"><b>column 2</b></th>                 

        </tr>   



            <tr bgcolor="#ffffff">
                <td align="left"> </td>             
                <td align="left"></td>                          

            </tr>   


            <tr bgcolor="#dddddd">
                <td align="left"> </td>             
                <td align="left"></td>                          

            </tr>   


            <tr bgcolor="#ffffff">
                <td align="left"> </td>             
                <td align="left"></td>                          

            </tr>
1
0
5/6/2017 9:04:44 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

maybe this

var rows = doc.DocumentNode
              .SelectNodes("//tr")
              .Select((z, i) => new
                  {
                    RowNumber = i,
                    Cells = z.ChildNodes.Where(c => c.NodeType == HtmlNodeType.Element) })
              .ToList();

rows.ForEach(row => Console.WriteLine("{0}: {1}", row.RowNumber, string.Join(", ", row.Cells.Select(z => z.InnerText))));
0
7/18/2013 10:21:04 AM

Related Questions

Loop over rows and columns with the HTML Agility Pack

You need to select these nodes using xpath:...foreach(HtmlNode cell in doc.DocumentElement.SelectNodes("//tr[@name='display']/td") { // get cell data }
asp.net c# html-agility-pack
asked by Oded

Get an html fragment from an html document using the Html Agility Pack.

I think you need to do it in pieces....you can do selectnodes of document for body or html as follows...doc.DocumentNode.SelectSingleNode("//body") // returns body with entire contents :) ...then you can check for null values for criteria and if that is provided, you can take the string as it is. ...Hope it helps :)
c# html html-agility-pack
asked by Manish Pansiniya

Selecting the current element in a loop using Html Agility Pack (XPATH)

Use ...var test = e.SelectNodes(".//a[@class='head']"); ...instead. Your current code ( ...//a[]...) searches all a elements starting from the root node. If you prefix it with a dot instead (....//a[]...) only the descendants of the current node will be considered. Since it is a direct child in your case you could of course also do:...var test = e....
.net c# html html-agility-pack xpath
asked by BrokenGlass

How to parse a webresponse and obtain a specific html element in C# using the Html Agility Pack

This console application code:... HtmlDocument doc = new HtmlDocument(); doc.Load(yourHtml); foreach (HtmlNode node in doc.DocumentNode.SelectNodes("//div[@class = 'labels']")) { Console.WriteLine(node.NextSibling.InnerText.Trim()); } ...will output this:...04:28:24 06:04:41
c# html html-agility-pack parsing
asked by Simon Mourier

Delete Table Column with HTML Agility Pack

You would need to iterate over each ...tr... and remove the 8th, 9th and 10th ...td... nodes from each....bool first = true; foreach (HtmlNode row in doc.DocumentNode.SelectNodes("//tr")) { if (first) { row.RemoveChild(row.SelectSingleNode("th[10]")); row.RemoveChild(row.SelectSingleNode("th[9]")); row.RemoveChild(ro...
asp.net c# html-agility-pack html-table
asked by Oded

Html Agility Pack loop through table rows and columns

Why don't you just select the ...td...s directly?...foreach (HtmlNode col in doc.DocumentNode.SelectNodes("//table[@id='table2']//tr//td")) Response.Write(col.InnerText); ...Alternately, if you really need the ...tr...s separately for some other processing, drop the ...//... and do:...foreach (HtmlNode row in doc.DocumentNode.SelectNodes("//tab...
.net c# html-agility-pack
asked by agentnega

C# - HTML Agility Pack - Node Collection - Loop table rows, selecting nth-child(2)

You can use XPath position filter to get only 2nd ...<td>... child from each ...<tr>... :...//table[@id='animal']//tbody//tr/td[2] ...It is actually equals to CSS ...:nth-of-type()... selector, and shows the same output as ...:nth-child()... only if all children are of the same type (means all children are ...<td>... in this case).
c# html-agility-pack
asked by har07

Strip Specific Styles from the Style attribute in Html string using Html Agility Pack

There doesn't appear to be any support for inline style string parsing in the HTML Agility Pack, but .NET does have some capabilities for this in ...System.Web.UI... to support WebForms controls. ...It's called the ...CssStyleCollection..., and it will convert your ...style... string into a nice array of string key/value pairs, and allow you to rem...
c# html-agility-pack html-parsing
asked by Memetican

Loop thorough multiple HTML tables in HTML Agility Pack

Since you want to parse multiple html tables you should return a ...DataSet... that will have one ...DataTable... per html table. If table headers are present, the code below will add column names to the corresponding ...DataTable.... The html table id will be used as the name for the ...DataTable... with which you can use to directly access from t...
c# html html-agility-pack xpath
asked by sly

Html Agility Pack Loop Through Table - Get cell value based on previous cell value

In your foreach loop you could use this:...var location = eachNode.FindElement(By.XPath(".//td[contains(text(),'Location')]/following-sibling::td));
c# html-agility-pack phantomjs selenium-webdriver web-scraping
asked by NotInventedHere

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