FormatAsTable
function FormatAsTable(sRange: string = null): void
Description
Formats the selected range of cells from the current sheet as a table (with the first row formatted as a header). As the first row is always formatted as a table header, you need to select at least two rows for the table to be formed correctly.
Parameters
- sRange
string
null The range of cells from the current sheet which will be formatted as a table.
Returns
void
Try It
var oWorksheet = Api.GetActiveSheet();
oWorksheet.FormatAsTable("A1:E10");