Definition Type: Element
Name: Delimiters
Namespace: urn:schemas-microsoft-com:office:excel
Containing Schema: excel.xsd
MinOccurs (1)
MaxOccurs (1)
Abstract
Documentation:
Contains the delimiters used to parse imported text.
Collapse XSD Schema Diagram:
Drilldown into TextQualifier in schema excel_xsd Drilldown into Tab in schema excel_xsd Drilldown into Space in schema excel_xsd Drilldown into SemiColon in schema excel_xsd Drilldown into Custom in schema excel_xsd Drilldown into Consecutive in schema excel_xsd Drilldown into Comma in schema excel_xsdXSD Diagram of Delimiters in schema excel_xsd (Microsoft Office 2003 Reference Schemas)
Collapse XSD Schema Code:
<xsd:element name="Delimiters">
    <xsd:annotation>
        <xsd:documentation>Contains the delimiters used to parse imported text.</xsd:documentation>
    </xsd:annotation>
    <xsd:complexType>
        <xsd:sequence>
            <xsd:element name="Comma" minOccurs="0">
                <xsd:annotation>
                    <xsd:documentation>Specifies whether the comma character is used as a delimiter when importing text.</xsd:documentation>
                </xsd:annotation>
            </xsd:element>
            <xsd:element name="Consecutive" minOccurs="0">
                <xsd:annotation>
                    <xsd:documentation>Specifies whether consecutive delimiters are treated as one when importing text.</xsd:documentation>
                </xsd:annotation>
            </xsd:element>
            <xsd:element name="Custom" type="xsd:string" minOccurs="0">
                <xsd:annotation>
                    <xsd:documentation>Contains a custom character to be used as a delimiter when importing text.</xsd:documentation>
                </xsd:annotation>
            </xsd:element>
            <xsd:element name="SemiColon" minOccurs="0">
                <xsd:annotation>
                    <xsd:documentation>Specifies whether the semicolon character is used as a delimiter when importing text.</xsd:documentation>
                </xsd:annotation>
            </xsd:element>
            <xsd:element name="Space" minOccurs="0">
                <xsd:annotation>
                    <xsd:documentation>Specifies whether the space character is used as a delimiter when importing text.</xsd:documentation>
                </xsd:annotation>
            </xsd:element>
            <xsd:element name="Tab" minOccurs="0">
                <xsd:annotation>
                    <xsd:documentation>Specifies whether the tab character is used as a delimiter when importing text.</xsd:documentation>
                </xsd:annotation>
            </xsd:element>
            <xsd:element name="TextQualifier" default="Quote" minOccurs="0">
                <xsd:annotation>
                    <xsd:documentation>Contains the character to be used for identifying text when importing text data.</xsd:documentation>
                </xsd:annotation>
                <xsd:simpleType>
                    <xsd:restriction base="xsd:string">
                        <xsd:enumeration value="None" />
                        <xsd:enumeration value="Quote" />
                    </xsd:restriction>
                </xsd:simpleType>
            </xsd:element>
        </xsd:sequence>
    </xsd:complexType>
</xsd:element>
Collapse Child Elements:
Name Type Min Occurs Max Occurs
Comma x:Comma 0 (1)
Consecutive x:Consecutive 0 (1)
Custom x:Custom 0 (1)
SemiColon x:SemiColon 0 (1)
Space x:Space 0 (1)
Tab x:Tab 0 (1)
TextQualifier x:TextQualifier 0 (1)