我正在嘗試使用html agility pack從html表中獲取數據,但只保留第一個表行中的數據。
我正在閱讀的HTML代碼如下:
<div id="mainDiv">
<table id="tbl">
<thead>
<tr>
<th class="tbl_col1">UserName</th>
<th class="tbl_col2">Points</th>
</tr>
</thead>
<tbody>
<tr data-source="provider1">
<td class="tbl_col1">
<a href="/Users/1090" id="UserLink" target="_blank">UserName1</a>
</td>
<td class="tbl_col2">
<a href="/UserPoints/1090" id="PointLink" target="_blank">1892 <span class="up_arrow"> </span></a>
</td>
</tr>
<tr data-source="provider2">
<td class="tbl_col1">
<a href="/Users/1090" id="UserLink" target="_blank">UserName2</a>
</td>
<td class="tbl_col2">
<a href="/UserPoints/1090" id="PointLink" target="_blank">3217 <span class="down_arrow"> </span></a>
</td>
</tr>
</tbody>
</table>
</div>
我正在使用此代碼
var UserTable = htmlDocument.DocumentNode.SelectSingleNode("//div[@id='mainDiv']").SelectSingleNode("//table[@id='tbl']").SelectSingleNode("//tbody").SelectNodes("//tr");
foreach (var row in UserTable)
{
if (row.Attributes["data-source"] != null)
{
string Source = row.Attributes["data-source"].Value;
string UserName = row.SelectSingleNode("td[@class='tbl_col1']").SelectSingleNode("//a[@id='UserLink']/text()").InnerText;
string Points = row.SelectSingleNode("td[@class='tbl_col2']").SelectSingleNode("//a[@id='PointLink']/text()").InnerText;
Console.WriteLine(Source + "\t" + UserName + "\t" + Points);
}
}
但我一直得到這個輸出:
provider1 UserName1 1892
provider2 UserName1 1892
您做出了錯誤的假設: //a[@id='UserLink']/text()
和//a[@id='PointLink']/text()
搜索整個文檔。這就是你獲得第一個tr
節點的原因。只需使用:
string UserName = row.SelectSingleNode("td[@class='tbl_col1']/a[@id='UserLink']/text()").InnerText;
string Points = row.SelectSingleNode("td[@class='tbl_col2']/a[@id='PointLink']/text()").InnerText;
您還可以真正簡化其餘代碼:
var UserTable = doc.DocumentNode.SelectNodes("//div[@id='mainDiv']/table[@id='tbl']/tbody/tr");
foreach (var row in UserTable)
{
if (row.Attributes["data-source"] != null)
{
string Source = row.Attributes["data-source"].Value;
string UserName = row.SelectSingleNode("td[@class='tbl_col1']/a[@id='UserLink']/text()").InnerText;
string Points = row.SelectSingleNode("td[@class='tbl_col2']/a[@id='PointLink']/text()").InnerText;
Console.WriteLine(Source + "\t" + UserName + "\t" + Points);
}
}