ColumnDataType Enum

Lists values used to define data formats of 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 enum ColumnDataType

VB.NET

Public Enum ColumnDataType

Members

Name	Description
General	Specifies that the type of column values should be recognized automatically based on the column content (numeric values will be converted to numbers, date values to dates, etc.).
Numeric	Specifies that column values should be interpreted as numbers. If conversion fails, column values are treated as strings.
DateTime	Specifies that column values should be interpreted as date and time values. If conversion fails, column values are treated as strings.
Boolean	Specifies that column values should be interpreted as boolean values. If conversion fails, column values are treated as strings.
Error	Specifies that column values should be interpreted as errors. If conversion fails, column values are treated as strings.
Text	Specifies that column values should be interpreted as text and corresponding cells will be formatted as text, so that anything you type into these cells will be treated as text including numbers.

Related API Members

The following properties accept/return ColumnDataType values:

• ColumnDataTypeCollection.Item[Int32]

Remarks

To specify a data type for a particular column in the imported document, assign the corresponding ColumnDataType enumeration member to the ColumnDataTypeCollection.Item property.