The requested page is not available for the requested platform. You are viewing the content for .NET Framework 4.5.2+ platform.
.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
Row

RangeDataSourceOptions Class

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

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v19.1.Core.dll

Declaration

public class RangeDataSourceOptions :
    DataSourceOptionsBase
Public Class RangeDataSourceOptions
    Inherits DataSourceOptionsBase
public class RangeDataSourceOptions :
    DataSourceOptionsBase
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.

Examples

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;

Inheritance

Object
DataSourceOptionsBase
RangeDataSourceOptions
See Also