TableToXml function

TABLETOXML() Description

The TABLETOXML() function converts a table of values to text in "XML" format.

Main Features Functions TABLETOXML

Syntax:

=TABLETOXML(Range; [RootElement]; [RowElement])

Parameters:

• Range: Range with values.
• [RootElement]: Optional. The name of the common tag for the selected dataset (table). The default is "table" .
• [RowElement]: Optional. The tag name for each data record (row). The default is "row" .

Example Usage

The TABLETOXML() function is easy to use. You just need to select a table or specify any range of cells with values and Excel will automatically return text in "XML" format:

=TABLETOXML(Range; "Countries")

We will have the following result:

This example uses the following values:

• Range: A2:D6 - The range from which the table with values is contained.
• RootElement: - The name of the general tag for the dataset. ("Countries")

Download extension

You can use the function TABLETOXML() by installing the extension YLC Utilities .

After that, this function will be available in all files that are opened in Excel .