RangeDataSourceOptions Class

Contains various options for a data source created from a cell range.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v18.2.Core.dll

Declaration

C#

public class RangeDataSourceOptions :
    DataSourceOptionsBase

VB.NET

Public Class RangeDataSourceOptions
    Inherits DataSourceOptionsBase

Remarks

A RangeDataSourceOptions object is created and passed as a parameter to the Range.GetDataSource or the WorksheetDataBindingCollection.CreateDataSource methods.

Example

Note

A complete sample project is available at https://github.com/DevExpress-Examples/an-example-of-using-a-cell-range-as-a-data-source-t483776

Form1.cs

RangeDataSourceOptions options = new RangeDataSourceOptions();
Worksheet sheet = spreadsheetControl1.ActiveWorksheet;
Range dataRange = sheet.Selection;
if (dataRange.Equals(sheet.Tables[0].Range))
    options.UseFirstRowAsHeader = true;
else {
    options.UseFirstRowAsHeader = false;
    options.DataSourceColumnTypeDetector = new MyColumnDetector();
}
options.SkipHiddenColumns = true;
rangeDS = dataRange.GetDataSource(options);
sheet.DataBindings.Error += DataBindings_Error;

Form1.vb

Dim options As New RangeDataSourceOptions()
Dim sheet As Worksheet = spreadsheetControl1.ActiveWorksheet
Dim dataRange As Range = sheet.Selection
If dataRange.Equals(sheet.Tables(0).Range) Then
    options.UseFirstRowAsHeader = True
Else
    options.UseFirstRowAsHeader = False
    options.DataSourceColumnTypeDetector = New MyColumnDetector()
End If
options.SkipHiddenColumns = True
rangeDS = dataRange.GetDataSource(options)
AddHandler sheet.DataBindings.Error, AddressOf DataBindings_Error

Inheritance

Object

DataSourceOptionsBase

RangeDataSourceOptions