Version

Configuring the Headers (Infragistics Excel Engine)

Topic Overview

Purpose

This topic explains how to show or hide the column and row headers.

Required background

The following topics are prerequisites to understanding this topic:

Topic Purpose

In this section you will find information that will help you to better understand the object model and the functionalities of the Infragistics Excel Engine.

In this topic

This topic contains the following sections:

Introduction

Headers summary

The column and row headers are used to visually identify columns and rows. They are also used to visually highlight the currently selected cell or cell region.

The following screenshot shows the worksheet’s headers. Because of the currently selected cell, the first row ("1") and the first column ("A") are with highlighted headers:

ExcelEngine 03.png

Headers Configuration Summary

Headers configuration summary chart

The following table explains briefly the configurable aspects of the column and row headers and maps them to the properties that configure them.

Configurable aspect Details Properties

Shows or hides the column and row headers.

Showing/Hiding

Overview

You can show or hide the column and row headers using the ShowRowAndColumnHeaders property.

Property settings

The following table maps the desired configuration to the property settings that manage it.

In order to: Use this property: And set it to:

Show the column and row headers

ShowRowAndColumnHeaders

True

Hide the column and row headers

ShowRowAndColumnHeaders

False

Example

The following code snippet demonstrates how to show the column and row headers on the first worksheet of the opened workbook.

In Visual Basic:

Me.spreadsheet1.Workbook.Worksheets(0).DisplayOptions.ShowRowAndColumnHeaders = True

In C#:

this.spreadsheet1.Workbook.Worksheets[0].DisplayOptions.ShowRowAndColumnHeaders = true;

Related Content

Topics

The following topics provide additional information related to this topic.

Topic Purpose

This topic explains how to show or hide the gridlines and set their color.

This topic explains how to prevent the user from editing the cell values in a worksheet.

This topic explains how to programmatically set the zoom level in a worksheet.