TextWizardSettings element

Contains the Text Import Wizard settings.

Usage

      
<TextWizardSettings />

    

Element Information

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

Elements and Attributes

Parent Elements

Element Description
QuerySource Describes the data source that a query table was based on when it was created from an external source.
QuerySource Contains information about the data source of a query.

Child Elements

Element Description
FormatSettings Contains format settings for the columns of imported text.
Delimiters Contains the delimiters used to parse imported text.
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.
Name 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.
Source Contains the name of a published item or range, or specifies the character set of a text data source.
StartRow Specifies the first row of a text data source to begin text import.
Decimal Contains the decimal separator character used to recognize numeric data when importing text.
ThousandSeparator Contains the thousands separator character used to recognize numeric data when importing text.

Attributes

None.

Definition

      
<xsd:element name="TextWizardSettings" type="TextWizardSettingsType" minOccurs="0" >
</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