ParameterTypeE complexType

Contains information about a query parameter.

Type Information

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

Elements and Attributes

Child Elements

Element Description
ExcelType Specifies the data type of a query parameter.
Formula Contains the formula corresponding to a defined name, a range in another workbook, a query parameter, or a PivotTable field, formula, or item.
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.
ParameterType Specifies a parameter type.
ParameterValue Specifies the value of a query parameter.
PromptString Contains the message displayed when the user is prompted for a query parameter.
NonDefaultName Specifies whether a query parameter has a user-defined name.
SQLType Specifies the SQL data type of a query parameter or PivotTable field.
RefreshOnChange Specifies whether the data from an external data source is refreshed when a cell used to calculate a parameter formula is changed.

Attributes

None.

Definition

      
<xsd:complexType name="ParameterTypeE" >
  <xsd:sequence>
    <xsd:element name="ExcelType" default="Text" minOccurs="0">
      <xsd:simpleType>
        <xsd:restriction base="xsd:string">
          <xsd:enumeration value="Boolean" />
          <xsd:enumeration value="Float" />
          <xsd:enumeration value="Integer" />
          <xsd:enumeration value="Text" />
        </xsd:restriction>
      </xsd:simpleType>
    </xsd:element>
    <xsd:element name="Formula" type="xsd:string" minOccurs="0">
    </xsd:element>
    <xsd:element name="Name" type="xsd:string">
    </xsd:element>
    <xsd:element name="ParameterType" default="Prompt" minOccurs="0">
      <xsd:simpleType>
        <xsd:restriction base="xsd:string">
          <xsd:enumeration value="Prompt" />
          <xsd:enumeration value="Value" />
          <xsd:enumeration value="Formula" />
        </xsd:restriction>
      </xsd:simpleType>
    </xsd:element>
    <xsd:element name="ParameterValue" type="xsd:string" minOccurs="0">
    </xsd:element>
    <xsd:element name="PromptString" type="xsd:string" minOccurs="0">
    </xsd:element>
    <xsd:element name="NonDefaultName" minOccurs="0">
    </xsd:element>
    <xsd:element name="SQLType" type="SQLTypeType" default="Character" minOccurs="0">
    </xsd:element>
    <xsd:element name="RefreshOnChange" minOccurs="0">
    </xsd:element>
  </xsd:sequence>
</xsd:complexType>


    
©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