SetDisplayHeadings

SetDisplayHeadings(isDisplayed)

Specifies whether the current sheet row/column headers must be displayed or not.

Parameters:

Name Type Description
isDisplayed boolean

Specifies whether the current sheet row/column headers must be displayed or not. The default value is true.

Returns:

This method doesn't return any data.

Example

Copy code
builder.CreateFile("xlsx");
var oWorksheet = Api.GetActiveSheet();
oWorksheet.GetRange("A2").SetValue("The sheet settings make it display no row/column headers");
oWorksheet.SetDisplayHeadings(false);
builder.SaveFile("xlsx", "SetDisplayHeadings.xlsx");
builder.CloseFile();

Resulting document