SpreadsheetViewOptions.ShowColumnHeaders Property

Gets or sets a value indicating whether column headers are displayed in the SpreadsheetControl.

Namespace : DevExpress.XtraSpreadsheet

Assembly : DevExpress.Spreadsheet.v25.2.Core.dll

NuGet Package : DevExpress.Spreadsheet.Core

Declaration

C#
VB.NET

csharp

[DefaultValue(true)]
public bool ShowColumnHeaders { get; set; }

<DefaultValue(True)>
Public Property ShowColumnHeaders As Boolean

Property Value

Type	Default	Description
Boolean	true

true , to display column headers; otherwise, false.

Property Paths

You can access this nested property as listed below:

Object Type	Path to ShowColumnHeaders
SpreadsheetControlOptions

.View .ShowColumnHeaders

Remarks

The following examples demonstrate how to hide the column and row headers in the SpreadsheetControl:

C#
VB.NET

csharp

spreadsheetControl.Options.View.ShowColumnHeaders = false;
spreadsheetControl.Options.View.ShowRowHeaders = false;

spreadsheetControl.Options.View.ShowColumnHeaders = False
spreadsheetControl.Options.View.ShowRowHeaders = False

This property value is not saved to a workbook. It only specifies how a document is displayed in the SpreadsheetControl.

To specify whether to show or hide column and row headers in a particular worksheet, use the WorksheetView.ShowHeadings property. Note that if you load a document with worksheets whose headers are hidden, neither column or row headers will be displayed, regardless of the SpreadsheetControl’s view options.