Power Query
published
Search
⌃K

Html.Table

Html.Table

Html.Table
function (optional html as nullable any, columnNameSelectorPairs as list, optional options as nullable record) as table

Description

Returns a table containing the results of running the specified CSS selectors against the provided html. An optional record parameter, options, may be provided to specify additional properties. The record can contain the following fields:
RowSelector

Category

Examples

Returns a table from a sample html text value.
Html.Table("<div class=""name"">Jo</div><span>Manager</span>", { {"Name", ".name"}, {"Title", "span"} }, [RowSelector=".name"])

table({"Name", "Title"}, { {"Jo", "Manager"} })

Extracts all the hrefs from a sample html text value.
Html.Table("<a href=""/test.html"">Test</a>", { {"Link", "a", each [Attributes][href]} })