ExcelSourceOptions.SkipHiddenColumns Property

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

Namespace: DevExpress.DataAccess.Excel

Assembly: DevExpress.DataAccess.v18.2.dll

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;

gridview-how-to-upload-an-excel-file-via-uploadcontrol-and-display-its-data-in-a-grid-t449148/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

gridview-how-to-upload-an-excel-file-via-uploadcontrol-and-display-its-data-in-a-grid-t449148/VB/T449148_VB/Models/Model.vb#L17

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