How to: Show and Hide Row and Column Headings
You need 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.
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.
A complete sample project is available at https://github.com/DevExpress-Examples/spreadsheet-document-server-api-e4339
// Hide row and column headings in the first worksheet. workbook.Worksheets.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®).