Count rows and columns in Html Table having subtables using HtmlAgilityPack

html-agility-pack html-table vb.net

Question

I'm parsing an Html table and I need the columns and rows count.

I tryed using:

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

But I get a wrong results if table has one or more subtables.

Here's a sample of html table I need to parse:

<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>

In this sample I need this results: Columns = 3 Rows = 5

How can I get the number of the rows and columns (only for the main table) without counting the subtable rows and columns?

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

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

I solved this way:

For columns: 

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

For Rows:

First: Check for SubTables

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

Then: Count Rows in Subtables and subtract from 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)

What I am trying to achieve is to extract all links with a href attribute that starts with http://, https:// or /. These links lie within a table (tbody > tr > td etc) with a certain class. I thought I could specify just the the a element without the whole path to it but it does not seem to work. I get a NullReferenceException at the line that sele...
c# html-agility-pack xpath
asked by Adam Asham

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

When ...HtmlNode... instances are returned, multiple calls for the same node will produce the same reference. You can use this to your advantage (although it's an implementation detail, so be careful)....Basically, you'd get all the descendants that are elements up until the node in question. You select the node to start from:...HtmlNode divNode ...
asp.net c# html-agility-pack
asked by casperOne

Html Agility Pack loop through table rows and columns

I have a table like this...<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 have a html table stucture. I need to get the value of the value of the first ...<td>... in the final ...<tr>... tag. Here is my table structure. The value I require from the below function getFinalNodeValue 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#

When there is a compound table inside an html file how can one count the rows of the parent table....What I mean by a compound table; a table in which other tables are contained within some of its cells....Here is my attempt at coding. Note I receive an incorrect values:... String htmlFile = "C:/Temp/Test_13.html"; HtmlDocument doc =...
c# html-agility-pack html-parsing linq
asked by user1944272

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

This worked,...//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 are selecting all the tables....Try selecting just the table that is a child of body, something like:...SelectSingleNode("//body/table"); ...Then, count the TRs in that node....Or, try doing it all in one step:...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 is an example :...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 ...The XPath means select ...<tr>... node having first child node ...<td>... equals ..."Power"..., t...
c# html-agility-pack
asked by har07

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

It is not possible to scrape the data with HtmlAgilityPack since it is loaded asynchronously. What you get when querying the page is its skeleton....What you could try is watch the network calls and see if a public webservice is called. Look out for 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 a mess tags are overlapping i suggest you use text nodes as your identifiers rather than indices for example....//td[./a[contains(text(),'See on Map')]]/td/text() ...to get ...120 NW 157TH AVE...Here is a full example that gets you everything... 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