TableToDict function

TABLETODICT() Description

The TABLETODICT() function converts values from the table LO Calc to the data type "dictionary" (dictionary) in Python or PHP format.

Main Features Functions TABLETODICT

Syntax:

=TABLETODICT(Range; [Format])

Parameters:

• Range: Table with headers and data.
• [Format]: Optional. Dictionary format (1-Python or 2-PHP). The default value is 1.

Example Usage

The TABLETODICT() function is easy to use. You just need to select a table and specify the desired dictionary format (1-Python or 2-PHP) and LibreOffice Calc will automatically return an array of values:

=TABLETODICT(Range; Format)

Example 1

This example uses the following values:

• Range: A2:D6 - A range containing a table of values.
• Format: E1 - Dictionary format Python (1) .

Example 2

This example uses the following values:

• Range: A2:D6 - A range containing a table of values.
• Format: E1 - Dictionary format PHP (2) .

Download the extension

You can use the TABLETODICT() 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.