Skip to main content

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

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:

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.

See Also