SetShowHeaders

Sets whether the header row is displayed for the table.

note

This functionality is available in paid ONLYOFFICE Docs editions.

Syntax

expression.SetShowHeaders(show);

expression - A variable that represents a ApiListObject class.

Parameters

Name	Required/Optional	Data type	Default	Description
show	Required	boolean		Specifies whether the header row is displayed for the table.

Returns

This method doesn't return any data.

Example

Show or hide the column header row of a table in a spreadsheet.

// How do I control whether a table displays its header row in a spreadsheet?

// Remove the header row from view to produce a compact table layout in a spreadsheet.

let worksheet = Api.GetActiveSheet();
worksheet.GetRange("A1").SetValue("Product");
worksheet.GetRange("B1").SetValue("Price");
worksheet.GetRange("A2").SetValue("Apples");
worksheet.GetRange("B2").SetValue(100);
worksheet.GetRange("A3").SetValue("Oranges");
worksheet.GetRange("B3").SetValue(150);
let table = worksheet.AddListObject("xlSrcRange", "A1:B3");
table.SetShowHeaders(false);

worksheet.GetRange("D1").SetValue("Show headers:");
worksheet.GetRange("E1").SetValue(table.GetShowHeaders());