Read invisible data from table with htmlagilitypack

Question

0.00/5 (No votes)

See more:

Hello,
I have this html with table.
I can get "col1" and "cal2" but I don't know how to get also value of "data-index", "data-name":

<table class="footable table" id="footable">
<tbody>
<tr class="trclass red" data-index="123" data-name="Apple">
<td class="col1" >Green</td>
<td class="col2" >1.25</td>
</td></tr>
</tbody>
</table>

HTML

Any help?

What I have tried:

// @Nuget: HtmlAgilityPack

using System;
using System.Xml;
using System.IO;
using HtmlAgilityPack;
					
public class Program
{
	public static void Main()
	{
		var html =
        @"<html>
		<tbody>
		<table id=\'footable\'>
			<tr class=\'trclass red\' data-index=\'123\' data-name=\'Apple\'>
			<td class=\'col1\' >Green</td>
			<td class=\'col2\' > 1.25</td></tr>
		</table>
		</tbody></html>";
		
		var htmlDoc = new HtmlDocument();
        htmlDoc.LoadHtml(html);
		
		var tbody = htmlDoc.DocumentNode.SelectNodes("//table[contains(@id, 'foo')]//tr//td");
	

		foreach(var nob in tbody)
		{
			 Console.Write(nob.InnerHtml);	

		}
	}
}

C#

Posted 5-May-19 7:41am

Member 10457276

Updated 6-May-19 1:49am

v3

Add a Solution

Comments

[no name] 5-May-19 17:06pm

"Tr" ending tag is missing.

Christian Graus 5-May-19 18:23pm

No it isn't :)

[no name] 5-May-19 23:44pm

			<tr class=\'trclass red\' data-index=\'123\' data-name=\'Apple\'>
			<td class=\'col1\' >Green</td>
			<td class=\'col2\' > 1.25</td>
		</table>

Christian Graus 5-May-19 23:50pm

Wow, that had a this morning (on the same line), I was sure of it

[no name] 6-May-19 0:13am

2 hours "after" I looked at it? And then it was changed back? You should be in the WH.

Christian Graus 6-May-19 0:38am

The WH? In the first instance, I am sure I saw on the same line. I figured you missed that. Given it's not there now, I assume I wasn't quite awake yet. Doesn't seem like a huge deal to me.....

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

F-ES Sitecore · Answer 1 · 2019-05-06T01:50:00

Solution 2

Use .Attributes on the node to read that nodes attributes like data-index etc

Select Nodes | Html Agility Pack[^]

Posted 6-May-19 1:50am

F-ES Sitecore

Christian Graus · Answer 2 · 2019-05-05T12:24:00

Solution 1

Why not just read it as XML, given that it is?

Posted 5-May-19 12:24pm

Christian Graus