corelibraries-devexpress-dot-dataaccess-dot-excel-dot-excelsourceoptions-35082f7e.md
Gets or sets whether to ignore hidden rows when importing data to ExcelDataSource.
Namespace : DevExpress.DataAccess.Excel
Assembly : DevExpress.DataAccess.v25.2.dll
NuGet Package : DevExpress.DataAccess
[DefaultValue(true)]
public bool SkipHiddenRows { get; set; }
<DefaultValue(True)>
Public Property SkipHiddenRows As Boolean
| Type | Default | Description |
|---|---|---|
| Boolean | true |
true , to ignore hidden rows when importing data; otherwise, false.
|
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.
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;
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
See Also