RANGE2HTML

Create an HTML table from a range with the same look and feel of the spreadsheet.

Syntax

RANGE2HTML(block,

[block2]

)

block

Literal, cell, or range to convert to HTML. For example: A1:C5.

[optional] block2

Another literal, cell, or range to add to the HTML code. For example: A7:D12.

RANGE2HTML(A1:C3) returns the code for a HTML table for the range A1:A3.