ExcelSourceOptions.SkipHiddenColumns Property

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

Namespace: DevExpress.DataAccess.Excel

Assembly: DevExpress.DataAccess.v23.2.dll

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

Declaration

C#

[DefaultValue(true)]
public bool SkipHiddenColumns { get; set; }

VB.NET

<DefaultValue(True)>
Public Property SkipHiddenColumns As Boolean

Property Value

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

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the SkipHiddenColumns 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#

how-to-create-data-access-library-data-sources-at-runtime-t424210/CS/ExcelDataSourceSnippets/Code.cs#L39

excelSourceOptions.SkipHiddenRows = false;
excelSourceOptions.SkipHiddenColumns = false;
excelDataSource.SourceOptions = excelSourceOptions;

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

excelSourceOptions.SkipHiddenRows = false;
excelSourceOptions.SkipHiddenColumns = false;
excelSourceOptions.UseFirstRowAsHeader = true;

VB.NET

how-to-create-data-access-library-data-sources-at-runtime-t424210/VB/ExcelDataSourceSnippets/Code.vb#L37

excelSourceOptions.SkipHiddenRows = False
excelSourceOptions.SkipHiddenColumns = False
excelDataSource.SourceOptions = excelSourceOptions

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

excelSourceOptions.SkipHiddenRows = False
excelSourceOptions.SkipHiddenColumns = False
excelSourceOptions.UseFirstRowAsHeader = True

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

excelSourceOptions.SkipHiddenRows = False
excelSourceOptions.SkipHiddenColumns = False
excelDataSource.SourceOptions = excelSourceOptions