officefileapi-devexpress-dot-spreadsheet-dot-datasourceoptionsbase-6ee65963.md
Gets or sets whether to include hidden columns into the binding range.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
public bool SkipHiddenColumns { get; set; }
Public Property SkipHiddenColumns As Boolean
| Type | Description |
|---|---|
| Boolean |
true , to skip hidden columns; otherwise, false. Default is false.
|
The SkipHiddenColumns and DataSourceOptionsBase.SkipHiddenRows properties operate differently depending on the data source type you use:
External Data Source
Cell Range as a Data Source
The following code snippet (auto-collected from DevExpress Examples) contains a reference 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.
winforms-spreadsheet-use-cell-range-as-data-source/CS/RangeDataSource/Form1.cs#L37
}
options.SkipHiddenColumns = true;
rangeDS = dataRange.GetDataSource(options);
winforms-spreadsheet-use-cell-range-as-data-source/VB/RangeDataSource/Form1.vb#L42
options.SkipHiddenColumns = True
rangeDS = dataRange.GetDataSource(options)
See Also