TDataConnectionFieldType Enumeration
These are the possible data types to use when importing text into the SpreadsheetML document. Strings are converted to these data types in the worksheet.
Syntax
Unit: FlexCel.Core
Members
| Name | Value | Description |
|---|---|---|
| General | 0 | The SpreadsheetML application decides the best fit data type based on the content. |
| Text | 1 | Field contains text. |
| MonthDayYear | 2 | Field contains a date in the order: month, day, year. |
| DayMonthYear | 3 | Field contains a date in the order: day, month, year. |
| YearMonthDay | 4 | Field contains a date in the order: year, month, day. |
| MonthYearDay | 5 | Field contains a date in the order: month, year, day. |
| DayYearMonth | 6 | Field contains a date in the order: day, year, month. |
| YearDayMonth | 7 | Field contains a date in the order: year, day, month. |
| Skip | 8 | Don't import this field at all. |
| EastAsianYearMonthDay | 9 | Field contains an East Asian date in the order: EA era year, month, day. |