Definition Type: ComplexType
Name: FormatSettingsType
Namespace: urn:schemas-microsoft-com:office:excel
Containing Schema: excel.xsd
Abstract
Documentation:
Contains the cell data type format settings for the columns of imported text.
Collapse XSD Schema Diagram:
Drilldown into FieldStart in schema excel_xsd Drilldown into FieldType in schema excel_xsdXSD Diagram of FormatSettingsType in schema excel_xsd (Microsoft Office 2003 Reference Schemas)
Collapse XSD Schema Code:
<xsd:complexType name="FormatSettingsType">
    <xsd:annotation>
        <xsd:documentation>Contains the cell data type format settings for the columns of imported text.</xsd:documentation>
    </xsd:annotation>
    <xsd:sequence>
        <xsd:element name="FieldType" default="AutoFormat" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies the cell data type formatting for a column.</xsd:documentation>
            </xsd:annotation>
            <xsd:simpleType>
                <xsd:restriction base="xsd:string">
                    <xsd:enumeration value="AutoFormat" />
                    <xsd:enumeration value="Text" />
                    <xsd:enumeration value="MDY" />
                    <xsd:enumeration value="DMY" />
                    <xsd:enumeration value="YMD" />
                    <xsd:enumeration value="MYD" />
                    <xsd:enumeration value="DYM" />
                    <xsd:enumeration value="YDM" />
                    <xsd:enumeration value="Skip" />
                </xsd:restriction>
            </xsd:simpleType>
        </xsd:element>
        <xsd:element name="FieldStart" type="xsd:int" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains the starting column number of a field used when importing text.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
    </xsd:sequence>
</xsd:complexType>
Collapse Child Elements:
Name Type Min Occurs Max Occurs
FieldType x:FieldType 0 (1)
FieldStart x:FieldStart 0 (1)
Collapse Derivation Tree:
Collapse References:
x:FormatSettings