Function TableToDict

TABLETODICT() Description

The TABLETODICT() function converts a value from a table Excel (Calc) into "dictionary" data type (dictionary) in Python or PHP format.

Key Features of the TABLETODICT Function

Syntax:

=TABLETODICT(Range; [Format])

Parameters:

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

Example of Use

The TABLETODICT() function is simple 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

In this example, the following values are used:

• Range: A2:D6 - Range which contains a table with values.
• Format: E1 - Python dictionary format (1).

Example 2

In this example, the following values are used:

• Range: A2:D6 - Range which contains a table with values.
• Format: E1 - PHP dictionary format (2).

Download the extension

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

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