Count rows and columns in Html Table having subtables using HtmlAgilityPack

html-agility-pack html-table vb.net

Question

I need the number of columns and rows in order to parse an HTML table.

I tried using

ColNum = mTables(1).SelectNodes(".//th").Count
RowNum = mTables(1).SelectNodes(".//tr").Count

However, if a table includes one or more subtables, I get the erroneous results.

I need to parse the following example of an HTML table:

<table border='1'>
    <tbody>
        <tr><th>Some Text</th><th>Some Text</th><th>Some Text</th></tr>
        <tr><td>Some data</td><td>Some data</td><td>Some data</td></tr>
        <tr><td>Some data</td><td>Some data
                     <table border='1'>
                         <tbody>
                             <tr><th>Some Text</th><th>Some Text</th></tr>
                             <tr><td>Some Data</td><td>Some Data</td></tr>
                         </tbody>
                     </table><td>Some data</td></tr>
        <tr><td>Some data</td><td>Some data</td><td>Some data</td></tr>
        <tr><td>Some data</td><td>Some data</td><td>Some data</td></tr>
    </tbody>
</table>

I need the following outcomes from this sample: 3 columns, 5 rows

How can I count the rows and columns (just in the main table) without counting the rows and columns in the subtables?

1
1
3/3/2016 10:21:53 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

I came up with a solution in the following manner:

in columns: 

ColNum = mTables(1).SelectSingleNode(".//tbody//tr[1]").SelectNodes(".//th").Count

In Rows:

Check for SubTables: First

Dim SubTbl%
Try
    SubTbl% = mTables(1).SelectNodes(".//table").Count
Catch ex As Exception
    SubTbl% = 0
End Try

Count the rows in the subtables, then deduct that number from the total rows.

Dim SubTRows% = 0
If SubTables > 0 Then
    For SubT As Short = 1 To SubTables
        Dim STRows% = mTables(1).SelectNodes(".//table[" & SubT & "]//tr").Count
        SubTRows += STRows
    Next
    RowsNum = mTables(1).SelectNodes(".//tr").Count - SubTRows
Else
    RowsNum = mTables(1).SelectNodes(".//tr").Count
End If
1
3/3/2016 11:10:10 AM

Related Questions

Using XPath, select all links from an HTML table (and HtmlAgilityPack)

To extract all links with a href attribute that begins with http://, https://, or / is what I'm aiming for. These connections are located inside a table with a certain class (tbody > tr > td, etc.). I though I could provide just the an element without including the whole route, however it does not seem to work. A NullReferenceException occurs at th...
c# html-agility-pack xpath
asked by Adam Asham

How can I get the html between 2 surrounding html elements using htmlagilitypack?

When ...HtmlNode... Multiple requests for the same node will result in the same reference since instances are returned. Although it's an implementation detail, you may benefit from this (just be cautious)....In essence, you would get all the descendants that are elements up to the questioned node. You pick the node to start at:...HtmlNode divNode =...
asp.net c# html-agility-pack
asked by casperOne

Html Agility Pack loop through table rows and columns

This is the table I have....<table border="0" cellpadding="0" cellspacing="0" id="table2"> <tr> <th>Name </th> <th>Age </th> </tr> <tr> <td>Mario </td> <th>Age: 78 </td> </tr> <tr> <td>Jane </td> <td>Age: 67 </td> </tr...
.net c# html-agility-pack
asked by mpora

Using HtmlAgilityPack to get the last <tr> of a html table

I've got a table structure in HTML. I must learn how much the initial value is worth....<td>... at the end...<tr>... tag. Here is the layout of my table. The value I need from the getFinalNodeValue method below is "...3...."... <table id="test"> <tr> <td>ID</td> <td>Name</td> <td>Age</td> ...
html html-agility-pack html-table
asked by SriniShine

How to count rows in a table in an html file C#

How does one count the rows of the parent table when there is a composite table within an HTML file?...What I mean by a composite table is a table that has cells that include data from several tables....Here is my coding effort. Note: I got the wrong values.... String htmlFile = "C:/Temp/Test_13.html"; HtmlDocument doc = new HtmlDocu...
c# html-agility-pack html-parsing linq
asked by user1944272

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

This functioned,...//table[@cellpadding='0' and @cellspacing='0']/tr[1]
c# html-agility-pack
asked by CoolArchTek

How to get count of parent row nodes from a html using HtmlAgilityPack

You have chosen all of the tables....Try just choosing tables that are children of body, such as:...SelectSingleNode("//body/table"); ...In such case, tally the TRs in that node....Or, try completing it all at once:...SelectNodes("//body/table/tr");
c# html-agility-pack
asked by Steve Wellens

HtmlAgilityPack method for returning value from a row in a table given column data

Here's an illustration:...HtmlDocument doc = new HtmlDocument(); //load your HTML to `doc` var result = doc.DocumentNode .SelectSingleNode("//tr[td[1]='Power']/td[3]") .InnerText; //at this point `result` hold value of 0 ...XPath stands for select....<tr>... node with a newborn node...<td>... equals ..."Power"... th...
c# html-agility-pack
asked by har07

Site uses Javascript and I am having trouble accessing it using htmlagilitypack

Since the data is loaded asynchronously, HtmlAgilityPack cannot scrape the data. When you query a page, you receive just its skeleton....You might attempt to discover whether a public webservice is called by keeping an eye on the network calls. Be wary of any json or xml data.
c# html-agility-pack web-scraping windows-phone-8
asked by samy

Using HtmlAgilityPack to get a specific row and column data

Your html is terrible. If your tags overlap, I advise using text nodes as IDs rather than indices, for instance.....//td[./a[contains(text(),'See on Map')]]/td/text() ...to get...120 NW 157TH AVE...Here is a complete illustration that covers all the bases.... var table = doc.DocumentNode.SelectSingleNode("//table[contains(@class,'DataRows')]");...
c# html-agility-pack xml-parsing xpath
asked by Xi Sigma

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