<xsd:complexType name="TextWizardSettingsType">
<xsd:annotation>
<xsd:documentation>Contains the Text Import Wizard settings.</xsd:documentation>
</xsd:annotation>
<xsd:sequence>
<xsd:element name="FormatSettings" type="FormatSettingsType">
<xsd:annotation>
<xsd:documentation>Contains format settings for the columns of imported text.</xsd:documentation>
</xsd:annotation>
</xsd:element>
<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>
<xsd:element name="Name" type="xsd:string">
<xsd:annotation>
<xsd:documentation>Contains the user-defined name of an object, range, or reference to another workbook, the location and name of a text file, or the built-in name of a range.</xsd:documentation>
</xsd:annotation>
</xsd:element>
<xsd:element name="Source" default="ANSI">
<xsd:annotation>
<xsd:documentation>Contains the name of a published item or range, or specifies the character set of a text data source.</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="ANSI" />
<xsd:enumeration value="MAC" />
<xsd:enumeration value="PC8" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="StartRow" type="xsd:int" default="1">
<xsd:annotation>
<xsd:documentation>Specifies the first row of a text data source to begin text import.</xsd:documentation>
</xsd:annotation>
</xsd:element>
<xsd:element name="Decimal" type="xsd:string">
<xsd:annotation>
<xsd:documentation>Contains the decimal separator character used to recognize numeric data when importing text.</xsd:documentation>
</xsd:annotation>
</xsd:element>
<xsd:element name="ThousandSeparator" type="xsd:string">
<xsd:annotation>
<xsd:documentation>Contains the thousands separator character used to recognize numeric data when importing text.</xsd:documentation>
</xsd:annotation>
</xsd:element>
</xsd:sequence>
</xsd:complexType>
|
XSD Schema Diagram:
