Using LINQ to XML to traverse an HTML table

Question

So, I can easily use LINQ to XML to traverse a properly set-up XML document. But I'm having some issues figuring out how to apply it to an HTML table. Here is the setup:

<table class='inner'
       width='100%'>
    <tr>
        <th>Area</th>
        <th>Date</th>
        <th>ID</th>
        <th>Name</th>
        <th>Email</th>
        <th>Zip Code</th>
        <th>Type</th>
        <th>Amount</th>
    </tr>
    <tr>
        <td>Data</td>
        <td>Data</td>
        <td>Data</td>
        <td>Data</td>
        <td>Data</td>
        <td>Data</td>
        <td>Data</td>
        <td>Data</td>
    </tr>
    <tr>
        <td>Data</td>
        <td>Data</td>
        <td>Data</td>
        <td>Data</td>
        <td>Data</td>
        <td>Data</td>
        <td>Data</td>
        <td>Data</td>
    </tr>
</table>

Essentially, there can be an endless number of rows, I want to be able to go row-by-row to check the data accordingly. Can anyone point me in the right direction? Should I be using tools other than LINQ for this?

EDIT: Sorry about the confusion, my issue is the fact that the page I am trying to gather data from is HTML, not XML. The exact extension is ".aspx.htm". This doesnt seem to load properly, and even if it did I'm not certain how to traverse the HTML page, given that there is one table before the table I'm trying to get data from.

For example, here is the XPATH to the table I'm trying to get info from:

/html/body/form/div[3]/table/tbody/tr[5]/td/table

you probably need to rephrase your question. I'm not seeing what's the road block from the description you have above ... causing the answers to be variations of use .Elements() / loop, even when you mentioned you have used linq to xml before. — eglasius
– eglasius, Commented Sep 13, 2010 at 17:52
@eglasius Yeah, thanks for the tip. I really didnt explain what my main issue was. Edited. — James
– James, Commented Sep 13, 2010 at 21:01

Jimmy Hoffa · Accepted Answer · 2010-09-13 17:11:19Z

5

XElement myTable = xdoc.Descendants("table").FirstOrDefault(xelem => xelem.Attribute("class").Value == "inner");
IEnumerable<IEnumerable<XElement>> myRows = myTable.Elements().Select(xelem => xelem.Elements());

foreach(IEnumerable<XElement> tableRow in myRows)
{
    foreach(XElement rowCell in tableRow)
    {
        // tada..
    }
}

answered Sep 13, 2010 at 17:11

Jimmy Hoffa

5,96734 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

SLaks · Accepted Answer · 2010-09-13 17:01:46Z

1

Once you have an XElement with the <table>, you can loop through its child Elements().

answered Sep 13, 2010 at 17:01

SLaks

891k182 gold badges1.9k silver badges2k bronze badges

Comments

John Nicholas · Accepted Answer · 2010-09-13 17:05:43Z

0

linq is like sql it performs set based operations.

You want to focus on using a foreach loop to iterate over the selected set of xelements -

answered Sep 13, 2010 at 17:05

John Nicholas

4,8364 gold badges33 silver badges51 bronze badges

Collectives™ on Stack Overflow

Using LINQ to XML to traverse an HTML table

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related