officefileapi-devexpress-dot-xtraspreadsheet-dot-import-9857c146.md
Lists values used to define data formats of columns in the imported CSV or TXT file.
Namespace : DevExpress.XtraSpreadsheet.Import
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
public enum ColumnDataType
Public Enum ColumnDataType
| 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.
|
The following properties accept/return ColumnDataType values:
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