ColumnDataTypeCollection Class

Stores data format settings for columns in the imported CSV or TXT file.

Namespace: DevExpress.XtraSpreadsheet.Import

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

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

public class ColumnDataTypeCollection

VB.NET

Public Class ColumnDataTypeCollection

Related API Members

The following members return ColumnDataTypeCollection objects:

• CsvDocumentImporterOptions.ColumnTypes
• TxtDocumentImporterOptions.ColumnTypes

Remarks

The ColumnDataTypeCollection collection provides a mapping from a set of document columns to a set of column data formats. The ColumnDataTypeCollection instance is available from the CsvDocumentImporterOptions.ColumnTypes or TxtDocumentImporterOptions.ColumnTypes property, depending on the file format of the imported document. To specify a data type for a particular column in the imported document, use the ColumnDataTypeCollection.Item property. Note that the column data format settings are taken into account for the imported document only if the CsvDocumentImporterOptions.ValueTypeDetectMode property (for a CSV file import process) or the TxtDocumentImporterOptions.ValueTypeDetectMode (for a TXT file import process) is set to CsvValueTypeDetectMode.Advanced.

Inheritance

Object

ColumnDataTypeCollection