.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+

ColumnDataTypeCollection.Item[Int32] Property

Gets or sets the data type of a specific column in the imported text document.

Namespace: DevExpress.XtraSpreadsheet.Import

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


public ColumnDataType this[int columnIndex] { get; set; }


Name Type Description
columnIndex Int32

A zero-based index of the column in the imported document whose data type should be set or obtained.

Property Value

Type Description

A ColumnDataType enumeration value which defines the data type of the specified column.


The following example demonstrates how to use the Item property of the ColumnDataTypeCollection collection (accessible from the CsvDocumentImporterOptions.ColumnTypes property) to specify a data type of the first column in a CSV document being loaded into the SpreadsheetControl.

private void SpreadsheetControl_BeforeImport(object sender, SpreadsheetBeforeImportEventArgs e)
    if (e.DocumentFormat == DocumentFormat.Csv)
        DevExpress.XtraSpreadsheet.Import.CsvDocumentImporterOptions options = (DevExpress.XtraSpreadsheet.Import.CsvDocumentImporterOptions)e.Options;
        // Specify the data format for the first column in the imported document.
        options.ColumnTypes[0] = DevExpress.XtraSpreadsheet.Import.ColumnDataType.Text;
See Also