我有這個代碼
foreach (var table in doc.DocumentNode.SelectNodes("//table[@id='formTbl']"))
{
foreach (var row in table.SelectNodes("tbody/tr"))
{
foreach (var cell in row.SelectNodes("td"))
{
if (X == 1)
{
Console.WriteLine($"Value: {cell.InnerText}");
X = 2;
string Value = cell.InnerText;
}
else if(X==2)
{
Console.WriteLine($"Column: {cell.InnerText}");
X = 1;
string Column = cell.InnerText;
}
}
}
}
我想讓 Json 像
{Column:Value, Column:Value, Column:Value}
我正在使用 Newtonsoft.Json 和 HtmlAgilityPack。有沒有辦法得到那個Json?到目前為止,我認為我能夠創造,{ {X = Column, Y= Value}, {X = Column, Y= Value} }但這不是我想要的。
E:表看起來像
<table>
<tr>
<td>Column1</td>
<td>Value1</td>
</tr>
<tr>
<td>Column2</td>
<td>Value2</td>
</tr>
<tr>
<td>Column3</td>
<td>Value3</td>
</tr>
<tr>
<td>Column4</td>
<td>Value4</td>
</tr>
</table>
uj5u.com熱心網友回復:
如果您的“列”名稱是唯一的,您可以簡單地使用字典并將其序列化。IE:
void Main()
{
var html =
@"<table id='formTbl'>
<tbody>
<tr>
<td>Column1</td>
<td>Value1</td>
</tr>
<tr>
<td>Column2</td>
<td>Value2</td>
</tr>
<tr>
<td>Column3</td>
<td>Value3</td>
</tr>
<tr>
<td>Column4</td>
<td>Value4</td>
</tr>
</tbody>
</table>";
var doc = new HtmlDocument();
doc.LoadHtml(html);
Dictionary<string, object> myDict = new Dictionary<string, object>();
foreach (var table in doc.DocumentNode.SelectNodes("//table[@id='formTbl']"))
{
foreach (var row in table.SelectNodes("tbody/tr"))
{
var cells = row.SelectNodes("td");
myDict.Add(cells[0].InnerText, cells[1].InnerText);
}
}
var json = JsonConvert.SerializeObject(myDict, Newtonsoft.Json.Formatting.Indented);
Console.WriteLine(json);
}
編輯:這輸出:
{
"Column1": "Value1",
"Column2": "Value2",
"Column3": "Value3",
"Column4": "Value4"
}
轉載請註明出處,本文鏈接:https://www.uj5u.com/net/331407.html
