RowCollection.Hide(Int32, Int32) Method

Hides the specified rows in a worksheet.

Namespace: DevExpress.Spreadsheet

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

Declaration

C#

void Hide(
    int first,
    int last
)

VB.NET

Sub Hide(
    first As Integer,
    last As Integer
)

Parameters

Name	Type	Description
first	Int32	A zero-based integer representing the index of the first row to be hidden.
last	Int32	A zero-based integer representing the index of the last row to be hidden.

Remarks

Use the Hide method to hide multiple rows at once. To hide an individual row, use the Row.Visible property.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the Hide(Int32, Int32) method.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

how-to-bind-a-spreadsheet-to-an-ms-sql-server-database-wpf-spreadsheet-t480591/CS/WpfSpreadsheet_BindToDataSource/MainWindow.xaml.cs#L89

    range.ClearContents();
    sheet.Rows.Hide(2, 9);
}

how-to-bind-a-spreadsheet-to-an-ms-sql-server-database-t472324/CS/SuppliersExample/Form1.cs#L74

    range.ClearContents();
    sheet.Rows.Hide(2, 9);
}

spreadsheet-document-api-examples-part1/CS/SpreadsheetExamples/SpreadsheetActions/RowAndColumnActions.cs#L127

// Hide rows from 6 to 8.
worksheet.Rows.Hide(5, 7);

VB.NET

how-to-bind-a-spreadsheet-to-an-ms-sql-server-database-wpf-spreadsheet-t480591/VB/WpfSpreadsheet_BindToDataSource/MainWindow.xaml.vb#L76

    range.ClearContents()
    sheet.Rows.Hide(2, 9)
End Sub

how-to-bind-a-spreadsheet-to-an-ms-sql-server-database-t472324/VB/SuppliersExample/Form1.vb#L70

    range.ClearContents()
    sheet.Rows.Hide(2, 9)
End Sub

spreadsheet-document-api-examples-part1/VB/SpreadsheetExamples/SpreadsheetActions/RowAndColumnActions.vb#L130

' Hide rows from 6 to 8.
worksheet.Rows.Hide(5, 7)