IDataSourceColumnTypeDetector Interface

Provides the capability to identify the name and type of each column in a data source created from a cell range.

Namespace: DevExpress.Spreadsheet

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

Declaration

C#

public interface IDataSourceColumnTypeDetector

VB.NET

Public Interface IDataSourceColumnTypeDetector

Related API Members

The following members return IDataSourceColumnTypeDetector objects:

• RangeDataSourceOptions.DataSourceColumnTypeDetector

Remarks

To specify column names and types using your own custom specifics, implement a class with the IDataSourceColumnTypeDetector interface and assign an instance of this class to the RangeDataSourceOptions.DataSourceColumnTypeDetector property of the options object passed to the Range.GetDataSource or the WorksheetDataBindingCollection.CreateDataSource method.

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

MyColumnDetector.cs

class MyColumnDetector : IDataSourceColumnTypeDetector {
    public string GetColumnName(int index, int offset, Range range) {
        if (offset > 3) return String.Format("Column{0}", index);
        string[] names = { "City", "Year", "Month", "Temperature" };
        return names[index];
    }

    public Type GetColumnType(int index, int offset, Range range) {
        Type defaultType = typeof(string);
        CellValue value = range[0, offset].Value;
        if (value.IsText) return typeof(string);
        if (value.IsBoolean) return typeof(bool);
        if (value.IsDateTime) return typeof(DateTime);
        if (value.IsNumeric) return typeof(double);
        return defaultType;
    }
}

MyColumnDetector.vb

Friend Class MyColumnDetector
    Implements IDataSourceColumnTypeDetector

    Public Function GetColumnName(ByVal index As Integer, ByVal offset As Integer, ByVal range As Range) As String Implements IDataSourceColumnTypeDetector.GetColumnName
        If offset > 3 Then
            Return String.Format("Column{0}", index)
        End If
        Dim names() As String = {"City", "Year", "Month", "Temperature"}
        Return names(index)
    End Function

    Public Function GetColumnType(ByVal index As Integer, ByVal offset As Integer, ByVal range As Range) As Type Implements IDataSourceColumnTypeDetector.GetColumnType
        Dim defaultType As Type = GetType(String)
        Dim value As CellValue = range(0, offset).Value
        If value.IsText Then
            Return GetType(String)
        End If
        If value.IsBoolean Then
            Return GetType(Boolean)
        End If
        If value.IsDateTime Then
            Return GetType(Date)
        End If
        If value.IsNumeric Then
            Return GetType(Double)
        End If
        Return defaultType
    End Function
End Class