TableToHtml function

TABLETOHTML() Description

The TABLETOHTML() function converts Excel (Calc) table in "HTML" format.

Main Features TABLETOHTML Functions

Syntax:

=TABLETOHTML(Range; [Indent])

Parameters:

• Range: Range with values.
• [Indent]: Optional. Initial indent for each nesting level. Defaults to "4".

Example Usage

The TABLETOHTML() function is easy to use. You just need to select a table or specify any range of cells with values and Excel (Calc) will automatically return the text in "HTML" format:

=TABLETOHTML(Range)

We will have the following result:

This example uses the following values:

• Range: A2:D6 - The range from which the table with values is contained.

Download extension

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

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