Contains information about the data source of a query.
Namespace | urn:schemas-microsoft-com:office:excel |
Schema name | XML Spreadsheet 2000 |
Element | Description |
---|---|
QueryType | Specifies the type of data source. |
CommandText | Contains the ODBC or OLE DB command string used to query data from a data source. |
CommandType | Contains the type of command specified. |
Maintain | Specifies whether a connection is kept open. |
Connection | Contains the connection string of a data source, or the location of the data for a chart. |
Maintain | Specifies whether a connection is kept open. |
Connection | Contains the connection string of a data source, or the location of the data for a chart. |
CommandText | Contains the ODBC or OLE DB command string used to query data from a data source. |
CommandType | Contains the type of command specified. |
DoNotJoinDelimiters | Specifies whether consecutive delimiters are treated as one when importing data from a Web page. |
NoTextToColumns | Specifies whether text data is converted to columns when importing data from a Web page. |
DisableDateRecognition | Contain a Boolean value indicating whether Excel should force strings that look like dates to be imported as text. |
EnableRedirections | Specifies a boolean that allows for web pages that are constructed a certain way for an Excel Web Query to get data directly from the data source rather than just the static information in the table on the web page. |
EditWebPage | Contains an HRef attribute that specifies the URL of a Web page to be used as the data source when EnableRedirections is set to true. |
RefreshedInXl9 | Contains a Boolean value to indicate whether the query table was last refreshed in Microsoft Excel 2000. |
EntirePage | Specifies whether the entire page is imported during a Web query. |
HTMLFormat | Specifies the amount of formatting imported into a query table from a Web page. |
URLString | Specifies the URL of a Web page used as the data source. |
WebPostString | Contains the POST method parameters of a Web query. |
RefreshInfo | Contains refresh information for the query. |
TextWizardSettings | Contains the Text Import Wizard settings. |
HTMLTables | Specifies the HTML tables on a Web page that are imported into a query table. |
UseSameSettings | Specifies whether the same text import options are used for an entire section on a Web page. |
Query97 | Specifies whether the query was created in Microsoft Excel 97. |
DoNotPromptForFile | Specifies whether to prompt the user for the name of a text file when performing a text file query. |
LocalConnection | Specifies the text that defines the connection to the local cube slice on the client computer. |
SourceConnectionFile | Contains the name of thefile where the data source connection settings came from when the query table or PivotTable view was created. |
SourceDataFile | Contains the name of source data file (such as an .mdb file) from which the data for the PivotTable view was originally retrieved. |
RobustConnect | Contains values that specify how data connections are to be handled when data is refreshed. |
RefreshTimeSpan | Contains an integer value specifying the number of minutes until the first data refresh and subsequent refreshes when automatic refreshes are enabled. |
VersionLastEdit | Reserved for future use. |
VersionLastRefresh | Reserved for future use. |
VersionRefreshableMin | Reserved for future use. |
Parameter | Contains information about a query parameter. |
Attribute | Type | Required | Description | Possible Values |
---|---|---|---|---|
HRef | xsd:string | required | Specifies the URL of a Web page to be used as the data source when EnableRedirections is set to true. | See external namespace. |
HRef | xsd:string | required | Specifies the URL of a Web page used as the data source. | See external namespace. |
<xsd:complexType name="QTQuerySourceType" >
<xsd:sequence>
<xsd:choice>
<xsd:sequence>
<xsd:element name="QueryType">
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="Access" />
<xsd:enumeration value="ADO" />
<xsd:enumeration value="DAO" />
<xsd:enumeration value="ODBC" />
<xsd:enumeration value="OLEDB" />
<xsd:enumeration value="Text" />
<xsd:enumeration value="Web" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="CommandText" type="xsd:string" minOccurs="0" maxOccurs="unbounded">
</xsd:element>
<xsd:element name="CommandType" type="CommandType" default="None" minOccurs="0">
</xsd:element>
<xsd:element name="Maintain" minOccurs="0">
</xsd:element>
<xsd:element name="Connection" type="xsd:string" minOccurs="0" maxOccurs="unbounded">
</xsd:element>
</xsd:sequence>
<xsd:sequence>
<xsd:element name="Maintain" minOccurs="0">
</xsd:element>
<xsd:element name="Connection" type="xsd:string" minOccurs="0" maxOccurs="unbounded">
</xsd:element>
<xsd:element name="CommandText" type="xsd:string" minOccurs="0" maxOccurs="unbounded">
</xsd:element>
<xsd:element name="CommandType" type="CommandType" default="None" minOccurs="0">
</xsd:element>
</xsd:sequence>
</xsd:choice>
<xsd:element name="DoNotJoinDelimiters" minOccurs="0">
</xsd:element>
<xsd:element name="NoTextToColumns" minOccurs="0">
</xsd:element>
<xsd:element name="DisableDateRecognition" minOccurs="0">
</xsd:element>
<xsd:element name="EnableRedirections" minOccurs="0">
</xsd:element>
<xsd:element name="EditWebPage" minOccurs="0">
<xsd:complexType>
<xsd:attribute name="HRef" type="xsd:string" use="required">
</xsd:attribute>
</xsd:complexType>
</xsd:element>
<xsd:element name="RefreshedInXl9" minOccurs="0">
</xsd:element>
<xsd:element name="EntirePage" minOccurs="0">
</xsd:element>
<xsd:element name="HTMLFormat" default="None" minOccurs="0">
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="All" />
<xsd:enumeration value="None" />
<xsd:enumeration value="RTF" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="URLString" minOccurs="0">
<xsd:complexType>
<xsd:attribute name="HRef" type="xsd:string" use="required" form="qualified">
</xsd:attribute>
</xsd:complexType>
</xsd:element>
<xsd:element name="WebPostString" type="xsd:string" minOccurs="0">
</xsd:element>
<xsd:element name="RefreshInfo" type="RefreshInfoType" minOccurs="0">
</xsd:element>
<xsd:element name="TextWizardSettings" type="TextWizardSettingsType" minOccurs="0">
</xsd:element>
<xsd:element name="HTMLTables" type="HTMLTablesType" minOccurs="0">
</xsd:element>
<xsd:element name="UseSameSettings" minOccurs="0">
</xsd:element>
<xsd:element name="Query97" minOccurs="0">
</xsd:element>
<xsd:element name="DoNotPromptForFile" minOccurs="0">
</xsd:element>
<xsd:element name="LocalConnection" type="xsd:string" minOccurs="0">
</xsd:element>
<xsd:element name="SourceConnectionFile" type="xsd:string" minOccurs="0">
</xsd:element>
<xsd:element name="SourceDataFile" type="xsd:string" minOccurs="0" maxOccurs="unbounded">
</xsd:element>
<xsd:element name="RobustConnect" type="OneZeroType" minOccurs="0">
</xsd:element>
<xsd:element name="RefreshTimeSpan" type="xsd:int" minOccurs="0">
</xsd:element>
<xsd:element name="VersionLastEdit" type="xsd:int" minOccurs="0">
</xsd:element>
<xsd:element name="VersionLastRefresh" type="xsd:int" minOccurs="0">
</xsd:element>
<xsd:element name="VersionRefreshableMin" type="xsd:int" minOccurs="0">
</xsd:element>
<xsd:element name="Parameter" type="ParameterTypeE" minOccurs="0" maxOccurs="unbounded">
</xsd:element>
</xsd:sequence>
</xsd:complexType>