ColumnCollection.Hide(String, String) Method

Hides the specified columns in a worksheet.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v24.1.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

void Hide(
    string firstColumnHeading,
    string lastColumnHeading
)

VB.NET

Sub Hide(
    firstColumnHeading As String,
    lastColumnHeading As String
)

Parameters

Name	Type	Description
firstColumnHeading	String	The heading of the first column to hide.
lastColumnHeading	String	The heading of the last column to hide.

Remarks

The method’s firstColumnHeading and lastColumnHeading parameters require column headings in the A1 reference style.

C#

// Hide columns from C to F.
worksheet.Columns.Hide("C", "F");

VB.NET

' Hide columns from C to F.
worksheet.Columns.Hide("C", "F")

Use the Column.Visible property to hide an individual column in a worksheet.

See how to hide rows and columns.