corelibraries-devexpress-dot-dataaccess-dot-excel-dot-excelsourceoptions-10c69ef1.md
Gets or sets whether to ignore hidden columns when importing data to ExcelDataSource.
Namespace : DevExpress.DataAccess.Excel
Assembly : DevExpress.DataAccess.v25.2.dll
NuGet Package : DevExpress.DataAccess
[DefaultValue(true)]
public bool SkipHiddenColumns { get; set; }
<DefaultValue(True)>
Public Property SkipHiddenColumns As Boolean
| Type | Default | Description |
|---|---|---|
| Boolean | true |
true , to ignore hidden columns when importing data; otherwise, false.
|
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.
excelSourceOptions.SkipHiddenRows = false;
excelSourceOptions.SkipHiddenColumns = false;
excelSourceOptions.UseFirstRowAsHeader = true;
data-access-library-create-data-sources-at-runtime/CS/ExcelDataSourceSnippets/Code.cs#L39
excelSourceOptions.SkipHiddenRows = false;
excelSourceOptions.SkipHiddenColumns = false;
excelDataSource.SourceOptions = excelSourceOptions;
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
data-access-library-create-data-sources-at-runtime/VB/ExcelDataSourceSnippets/Code.vb#L37
excelSourceOptions.SkipHiddenRows = False
excelSourceOptions.SkipHiddenColumns = False
excelDataSource.SourceOptions = excelSourceOptions
See Also