The requested page is not available for the requested platform. You are viewing the content for .NET Framework 4.5.2+ platform.

How to: Show and Hide Row and Column Headings

Important

You require a license to the DevExpress Office File API or DevExpress Universal Subscription to use these examples in production code. Refer to the DevExpress Subscription page for pricing information.

Cells in a worksheet are arranged in rows (Worksheet.Rows) and columns (Worksheet.Columns). Each row and column has a unique name (rows use numbers "1", "2", "3",..., "1048576", and columns use letters "A", "B", "C",...,"XFD"). Row and column names are displayed on a worksheet's left and top side, respectively. Use the Worksheet.ActiveView.ShowHeadings (WorksheetView.ShowHeadings) property to control row and column headings' visibility in a worksheet.

Note

Use the WorksheetPrintOptions.PrintHeadings property to specify whether row and column headings should appear in a printout. Refer to the How to: Specify Print Settings document for details on how to specify print options for a worksheet.

// Hide row and column headings in the first worksheet.
workbook.Worksheets[0].ActiveView.ShowHeadings = false;

The image below shows a worksheet's appearance with visible and hidden row and column headings (the workbook is opened in Microsoft® Excel®).

Spreadsheet_Worksheet_ActiveView_ShowHeadings