How to: Hide a Row or Column

• Apr 12, 2019

The example below demonstrates how to control the visibility of rows and columns in a worksheet using the IXlRow.IsHidden and IXlColumn.IsHidden properties.

Note

You can also hide a row or column in a worksheet by setting the row height (IXlRow.HeightInPixels) or column width (IXlColumn.WidthInCharacters or IXlColumn.WidthInPixels) to 0, respectively (see the How to: Specify Row Height and Column Width document).

Tip

A complete sample project is available in the DevExpress Code Examples database at http://www.devexpress.com/example=T253492.

C#

// Create a new worksheet.
using (IXlSheet sheet = document.CreateSheet()) 
{
    // Hide the column B in the worksheet.
    using (IXlColumn column = sheet.CreateColumn(1))
    {
        column.IsHidden = true;
    }

    // Hide the third row in the worksheet.
    using (IXlRow row = sheet.CreateRow(2))
    {
        row.IsHidden = true;
    }
}

VB.NET

' Create a new worksheet.
Using sheet As IXlSheet = document.CreateSheet()
    ' Hide the column B in the worksheet.
    Using column As IXlColumn = sheet.CreateColumn(1)
        column.IsHidden = True
    End Using

    ' Hide the third row in the worksheet.
    Using row As IXlRow = sheet.CreateRow(2)
        row.IsHidden = True
    End Using
End Using