TableToSql function

TABLETOSQL() Description

The function TABLETOSQL() values from the table in SQL team INSERT INTO .

Also, this function takes the name of the sheet as the name of the SQL table.

Main Features Functions TABLETOSQL

Syntax:

=TABLETOSQL(Range)

Parameters:

• Range: A range of values in the form of a table with headers.

Example Usage

The TABLETOSQL() function is easy to use. You just need to select the table with headers and LibreOffice Calc will automatically return the text in SQL command "INSERT INTO" format:

=TABLETOSQL(Range)

We will have the following result:

This example uses the following values:

• Range: A2:D16 - A range containing a table of headers and values.

Download the extension

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