[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
ST_ExternalConnectionType (Text Field Datatype)
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.
This simple type's contents are a restriction of the XML Schema string datatype.
The following are possible enumeration values for this type:
|
Enumeration Value |
Description |
|
DMY (Day Month Year) |
Field contains a date in the order: day, month, year. |
|
DYM (Day Year Month) |
Field contains a date in the order: day, year, month. |
|
EMD (East Asian Year Month Day) |
Field contains an East Asian date in the order: EA era year, month, day. |
|
general (General) |
The SpreadsheetML application decides the best fit data type based on the content. |
|
MDY (Month Day Year) |
Field contains a date in the order: month, day, year. |
|
MYD (Month Day Year) |
Field contains a date in the order: month, year, day. |
|
skip (Skip Field) |
Don't import this field at all. |
|
text (Text) |
Field contains text. |
|
YDM (Year Day Month) |
Field contains a date in the order: year, day, month. |
|
YMD (Year Month Day) |
Field contains a date in the order: year, month, day. |
|
Referenced By |
|
textField@type (§3.13.10) |
The following XML Schema fragment defines the contents of this simple type:
<simpleType name="ST_ExternalConnectionType">
<restriction base="xsd:string">
<enumeration value="general"/>
<enumeration value="MDY"/>
<enumeration value="DMY"/>
<enumeration value="YMD"/>
<enumeration value="MYD"/>
<enumeration value="DYM"/>
<enumeration value="YDM"/>
<enumeration value="skip"/>
<enumeration value="EMD"/>
</restriction>
</simpleType>