TableToDict function

TABLETODICT() Description

The TABLETODICT() function converts values from a table Excel (Calc) in 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). Default 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 Excel (Calc) will automatically return an array of values:

=TABLETODICT(Range; Format)

Example 1

This example uses the following values:

• Range: A2:D6 - The range from which the table with values is contained.
• Format: E1 - Dictionary format Python (1) .

Example 2

This example uses the following values:

• Range: A2:D6 - The range from which the table with values is contained.
• Format: E1 - Dictionary format PHP (2) .

Download extension

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

After that, this function will be available in all files that are opened in Excel (LibreOffice Calc) .