Function TableToXml

TABLETOXML() Description

The TABLETOXML() function is designed for quick conversion of tabular values into XML text format. It automatically structures data in the form of hierarchical tags that clearly define each element of the table.

The obtained result is perfectly suitable for exchanging data between various information systems and storing configurations.

Key Features of the TABLETOXML Function

Syntax:

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

Parameters:

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

Example of 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 (Calc) will automatically return the 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 a table with values.
• RootElement: - The name of the common 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 will be opened in Excel (LibreOffice Calc).