Forum Discussion
How to parse <td> tags with HTML.Table ?
Hello,
I am trying to figure out how HTML.Table works. Microsoft description of this function is very basic. Let's say I have a simple HTML code "<td> 100.67</td>" from which I want to extract the value (100.67). Trying this code, but it does not give me wanted result, although does not complain about syntax:
= Html.Table("<td> 100.67</td>", { {"myValue", "td"}})
This one does not work either:
= Html.Table("<td>100.67</td>", { {"myValue", "td"}}, [RowSelector="td"])
What am I missing here?
Hi gvg
It looks like the issue might be with the way the HTML code is formatted. The Html.Table function expects the input HTML code to be in a specific format, with a table structure containing rows and columns. The code you provided is just a single cell in a table, without any surrounding table structure.
Note that in this example, the HTML code has a table structure, with a single row and a single cell containing the value 100.67.
Also, the second parameter of Html.Table is a list of name-selector pairs, not a record. So you should use
let
html = "<table><tr><td>100.67</td></tr></table>",
#"Extracted Table" = Html.Table(html, {{"myValue", "td"}})
in
#"Extracted Table"
2 Replies
Hi gvg
It looks like the issue might be with the way the HTML code is formatted. The Html.Table function expects the input HTML code to be in a specific format, with a table structure containing rows and columns. The code you provided is just a single cell in a table, without any surrounding table structure.
Note that in this example, the HTML code has a table structure, with a single row and a single cell containing the value 100.67.
Also, the second parameter of Html.Table is a list of name-selector pairs, not a record. So you should use
let
html = "<table><tr><td>100.67</td></tr></table>",
#"Extracted Table" = Html.Table(html, {{"myValue", "td"}})
in
#"Extracted Table"Yes, you are right. Thank you!
