Delimiters element

Contains the delimiters used to parse imported text.

Usage

      
<Delimiters />

    

Element Information

Element type Anonymous
Namespace urn:schemas-microsoft-com:office:excel
Schema name XML Spreadsheet 2000

Elements and Attributes

Parent Elements

Element Description
TextWizardSettings Contains the Text Import Wizard settings.

Child Elements

Element Description
Comma Specifies whether the comma character is used as a delimiter when importing text.
Consecutive Specifies whether consecutive delimiters are treated as one when importing text.
Custom Contains a custom character to be used as a delimiter when importing text.
SemiColon Specifies whether the semicolon character is used as a delimiter when importing text.
Space Specifies whether the space character is used as a delimiter when importing text.
Tab Specifies whether the tab character is used as a delimiter when importing text.
TextQualifier Contains the character to be used for identifying text when importing text data.

Attributes

None.

Definition

      
<xsd:element name="Delimiters" >
  <xsd:complexType>
    <xsd:sequence>
      <xsd:element name="Comma" minOccurs="0">
      </xsd:element>
      <xsd:element name="Consecutive" minOccurs="0">
      </xsd:element>
      <xsd:element name="Custom" type="xsd:string" minOccurs="0">
      </xsd:element>
      <xsd:element name="SemiColon" minOccurs="0">
      </xsd:element>
      <xsd:element name="Space" minOccurs="0">
      </xsd:element>
      <xsd:element name="Tab" minOccurs="0">
      </xsd:element>
      <xsd:element name="TextQualifier" default="Quote" minOccurs="0">
        <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>


    
©2003-2004 Microsoft Corporation. All rights reserved. Permission to copy, display and distribute this document is available at: http://msdn.microsoft.com/library/en-us/odcXMLRef/html/odcXMLRefLegalNotice.asp