You need to get a reference to the table (which you might be able to do using its css class if you haven't already accomplished this). Then you obtain the collection of rows and burrow into them using the ElementAt method:
var table = doc.DocumentNode.Descendants("table")
.Where(t => t.GetAttributeValue("class", "").Equals("tabcontent"))
.First();
var rows = table.Descendants("tr");
var thirdCellInThirdRow = rows.ElementAt(2).Descendants("td").ElementAt(2);
<div>@thirdCellInThirdRow.InnerText</div>
dow7
Member
572 Points
643 Posts
Using the HtmlAgilityPack to parse HTML and update the database
Jun 05, 2015 05:08 AM|dow7|LINK
I read mikesdotnetting's post (http://www.mikesdotnetting.com/article/273/using-the-htmlagilitypack-to-parse-html-in-asp-net) and i trying to parse a table which is inside another table which is inside another table...on a webpage.
How to get the data of:
3rd <td> on 3rd <tr>
3rd <td> on 4th <tr>
3rd <td> on 5th <tr>
3rd <td> on 6th <tr>
3rd <td> on 14th <tr>
3rd <td> on 15th <tr>
The html code is below:
<table class="tabcontent" cellspacing="0" cellpadding="3" width="100%" border="1" frame="VOID" rules="ALL" bordercolor="#D3DAD3"> <tbody> <tr> <td colspan="5"> <b> Last update :</b> 12:17:33 04.06.2015 </td> </tr> <tr> <td colspan="2"> </td> <td align="right" colspan="3" valign="top">all/fx</td> </tr> <tr> <td nowrap="">USD</td> <td nowrap="">USD</td> <td align="right" nowrap="">124.27</td> <td align="right" nowrap="">-2.51</td> <td width="20" align="center"> <img src="#"> </td> </tr> <tr> <td nowrap="">EUR</td> <td nowrap="">EUR</td> <td align="right" nowrap="">140.91</td> <td align="right" nowrap="">-0.02</td> <td width="20" align="center"> <img src="#"> </td> </tr> <tr> <td nowrap="">GBP</td> <td nowrap="">GBP</td> <td align="right" nowrap="">191.69</td> <td align="right" nowrap="">-1.72</td> <td width="20" align="center"> <img src="#"> </td> </tr> <tr> <td nowrap="">CHF</td> <td nowrap="">CHF</td> <td align="right" nowrap="">133.73</td> <td align="right" nowrap="">-1.69</td> <td width="20" align="center"> <img src="#"> </td> </tr> <tr> <td nowrap="">JPY</td> <td nowrap="">JPY</td> <td align="right" nowrap="">100.17</td> <td align="right" nowrap="">-1.77</td> <td width="20" align="center"> <img src="#"> </td> </tr> <tr> <td nowrap="">AUD</td> <td nowrap="">AUD</td> <td align="right" nowrap="">96.22</td> <td align="right" nowrap="">-2.34</td> <td width="20" align="center"> <img src="#"> </td> </tr> <tr> <td nowrap="">CAD</td> <td nowrap="">CAD</td> <td align="right" nowrap="">99.84</td> <td align="right" nowrap="">-2.05</td> <td width="20" align="center"> <img src="#"> </td> </tr> <tr> <td nowrap="">SEK</td> <td nowrap="">SEK</td> <td align="right" nowrap="">15.04</td> <td align="right" nowrap="">+0.04</td> <td width="20" align="center"> <img src="#"> </td> </tr> <tr> <td nowrap="">NOK</td> <td nowrap="">NOK</td> <td align="right" nowrap="">16.08</td> <td align="right" nowrap="">-0.12</td> <td width="20" align="center"> <img src="#"> </td> </tr> <tr> <td nowrap="">DKK</td> <td nowrap="">DKK</td> <td align="right" nowrap="">18.90</td> <td align="right" nowrap="">+0.02</td> <td width="20" align="center"> <img src="#"> </td> </tr> <tr> <td nowrap="">SDR</td> <td nowrap="">SDR</td> <td align="right" nowrap="">173.63</td> <td align="right" nowrap="">-2.87</td> <td width="20" align="center"> <img src="#"> </td> </tr> <tr> <td nowrap="">Gold(OZ 1)</td> <td nowrap="">XAU</td> <td align="right" nowrap="">146938.39</td> <td align="right" nowrap="">-3,566.79</td> <td width="20" align="center"> <img src="#"> </td> </tr> <tr> <td nowrap="">Silver(OZ 1)</td> <td nowrap="">XAG</td> <td align="right" nowrap="">2036.70</td> <td align="right" nowrap="">-64.00</td> <td width="20" align="center"> <img src="#"> </td> </tr> </tbody> </table>Mikesdotnett...
All-Star
184243 Points
26625 Posts
Moderator
MVP
Re: Using the HtmlAgilityPack to parse HTML and update the database
Jun 05, 2015 07:07 AM|Mikesdotnetting|LINK
You need to get a reference to the table (which you might be able to do using its css class if you haven't already accomplished this). Then you obtain the collection of rows and burrow into them using the ElementAt method:
var table = doc.DocumentNode.Descendants("table") .Where(t => t.GetAttributeValue("class", "").Equals("tabcontent")) .First(); var rows = table.Descendants("tr"); var thirdCellInThirdRow = rows.ElementAt(2).Descendants("td").ElementAt(2); <div>@thirdCellInThirdRow.InnerText</div>ASP.NET Tutorials | Learn Entity Framework Core