ExcelSourceOptions.SkipHiddenRows Property

Gets or sets whether to ignore hidden rows when importing data to ExcelDataSource.

Namespace: DevExpress.DataAccess.Excel

Assembly: DevExpress.DataAccess.v24.1.dll

NuGet Packages: DevExpress.DataAccess, DevExpress.Win.PivotGrid, DevExpress.Win.TreeMap

Declaration

C#

[TypeConverter(typeof(BooleanTypeConverter))]
public bool SkipHiddenRows { get; set; }

VB.NET

<TypeConverter(GetType(BooleanTypeConverter))>
Public Property SkipHiddenRows As Boolean

Property Value

Type	Description
Boolean	true, to ignore hidden rows when importing data; otherwise, false.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the SkipHiddenRows property.

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#

asp-net-mvc-grid-upload-excel-file-using-upload-control-and-display-data-in-grid/CS/T449148/Models/Model.cs#L31

excelSourceOptions.ImportSettings = excelWorksheetSettings;
excelSourceOptions.SkipHiddenRows = false;
excelSourceOptions.SkipHiddenColumns = false;

data-access-library-create-data-sources-at-runtime/CS/ExcelDataSourceSnippets/Code.cs#L38

excelSourceOptions.ImportSettings = excelWorksheetSettings;
excelSourceOptions.SkipHiddenRows = false;
excelSourceOptions.SkipHiddenColumns = false;

VB.NET

asp-net-mvc-grid-upload-excel-file-using-upload-control-and-display-data-in-grid/VB/T449148_VB/Models/Model.vb#L16

excelSourceOptions.ImportSettings = excelWorksheetSettings
excelSourceOptions.SkipHiddenRows = False
excelSourceOptions.SkipHiddenColumns = False

reporting-winforms-bind-excel-runtime/VB/BindingReportToExcelWorkbook/Form1.vb#L29

excelSourceOptions.ImportSettings = excelWorksheetSettings
excelSourceOptions.SkipHiddenRows = False
excelSourceOptions.SkipHiddenColumns = False

data-access-library-create-data-sources-at-runtime/VB/ExcelDataSourceSnippets/Code.vb#L36

excelSourceOptions.ImportSettings = excelWorksheetSettings
excelSourceOptions.SkipHiddenRows = False
excelSourceOptions.SkipHiddenColumns = False