Function TableToXml

TABLETOXML() Description

The TABLETOXML() function converts a table with values into text in XML format.

Key Features of the TABLETOXML Function

Syntax:

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

Parameters:

• Range: Range with values.
• [RootElement]: Optional. Name of the common tag for the selected data set (table). By default, the value "table" is used.
• [RowElement]: Optional. Name of the tag for each data record (row). By default, the value "row" is used.

Example of Use

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

=TABLETOXML(Range; "Countries")

We will get the following result:

In this example, the following values are used:

• Range: A2:D6 - The range that contains the table with values.
• RootElement: - Name of the common tag for the data set. ("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 opened in Excel (LibreOffice Calc).