Html.Table

Syntax

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

About

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

To generate the CSS selectors automatically, try using the Get Data from Web by example feature.

Example 1

Returns a table from a sample html text value.

Usage

Html.Table("<div class=""name"">Jo</div><span>Manager</span>", {{"Name", ".name"}, {"Title", "span"}}, [RowSelector=".name"])

Output

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

Example 2

Extracts all the hrefs from a sample html text value.

Usage

Html.Table("<a href=""/test.html"">Test</a>", {{"Link", "a", each [Attributes][href]}})

Output

#table({"Link"}, {{"/test.html"}})