Skip to main content

ExcelSourceOptionsBase.SkipEmptyRows Property

Gets or sets whether or not to include empty rows into the resulting ExcelDataSource.

Namespace: DevExpress.DataAccess.Excel

Assembly: DevExpress.DataAccess.v24.1.dll

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

Declaration

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

Property Value

Type Description
Boolean

true, to exclude the empty rows from the resulting ExcelDataSource; otherwise, false.

Property Paths

You can access this nested property as listed below:

Library Object Type Path to SkipEmptyRows
Cross-Platform Class Library BeforeFillEventArgs
.SourceOptions .SkipEmptyRows
ExcelDataSource
.SourceOptions .SkipEmptyRows
DataSourceModel
.SourceOptions .SkipEmptyRows
ExcelDataSourceModel
.SourceOptions .SkipEmptyRows
IExcelDataSourceModel
.SourceOptions .SkipEmptyRows
IChooseFileOptionsPageView
.SourceOptions .SkipEmptyRows
WinForms Controls ChooseFileOptionsPageView
.SourceOptions .SkipEmptyRows
Dashboard DashboardExcelDataSourceBeforeFillEventArgs
.SourceOptions .SkipEmptyRows
ExcelDataSourceBeforeFillEventArgs
.SourceOptions .SkipEmptyRows
.NET Reporting Tools XtraReportModel
.SourceOptions .SkipEmptyRows

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the SkipEmptyRows 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.

See Also