TableToXml function

TABLETOXML() Description

The TABLETOXML() function converts a table of values into 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 data set (table). The default value is used "table" .
• [RowElement]: Optional. Tag name for each record (line) of data. The default value is used "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 LibreOffice Calc will automatically return the text in "XML" format:

=TABLETOXML(Range; "Countries")

We will have the following result:

This example uses the following values:

• Range: A2:D6 - A range containing a table of values.
• RootElement: - The generic tag name for the dataset. ("Countries")

Download the extension

You can use the TABLETOXML() function by installing the extension "YLC_Utilities.oxt" .

After that, this function will be available in all files that will be opened in LibreOffice Calc.