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. |