Get Started
Usage API
More information

SetDisplayHeadings

SetDisplayHeadings(isDisplayed)

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

Parameters:

Name Type Description
isDisplayed bool

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");
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