RefreshInfoType complexType

Contains information to be used when data is refreshed.

Type Information

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

Elements and Attributes

Child Elements

Element Description
NextId Specifies the next available unique identification number that can be assigned to a column.
ColumnInfo Contains information about a column.
DoNotPersist Specifies whether to preserve sort and filter settings for a column.
DoNotPersistSort Specifies whether sort settings are preserved for a column.
DoNotPersstAF Specifies whether filter settings are preserved for a column.
Sort Specifies a range of cells or the name of a range to sort, or whether a query table has been sorted.
CaseSensitive Specifies whether sorting is case-sensitive.
FuturePersist Reserved for future use.
HeaderRow Specifies whether the header row is included in a sort.
IdWrapped Specifies whether all possible identification numbers assigned to columns have been used and whether previously used numbers are being implemented.
NoTitles Specifies whether column titles are included in a query.
AlertVersion Reserved for future use.
SortOrder Specifies the index number of a sort order used in a custom sort.
ExtraLeftColumns Specifies the number of columns to the left of a query table included in a sort.
ExtraRightColumns Specifies the number of columns to the right of a query table included in a sort.
DeletedTitle Contains the column title deleted from a query.

Attributes

None.

Definition

      
<xsd:complexType name="RefreshInfoType" >
  <xsd:sequence>
    <xsd:element name="NextId" type="xsd:integer">
    </xsd:element>
    <xsd:element name="ColumnInfo" type="ColumnInfoType" minOccurs="0" maxOccurs="unbounded">
    </xsd:element>
    <xsd:element name="DoNotPersist" minOccurs="0">
    </xsd:element>
    <xsd:element name="DoNotPersistSort" minOccurs="0">
    </xsd:element>
    <xsd:element name="DoNotPersstAF" minOccurs="0">
    </xsd:element>
    <xsd:element name="Sort" type="xsd:string" minOccurs="0">
    </xsd:element>
    <xsd:element name="CaseSensitive" minOccurs="0">
    </xsd:element>
    <xsd:element name="FuturePersist" minOccurs="0">
    </xsd:element>
    <xsd:element name="HeaderRow" minOccurs="0">
    </xsd:element>
    <xsd:element name="IdWrapped" minOccurs="0">
    </xsd:element>
    <xsd:element name="NoTitles" minOccurs="0">
    </xsd:element>
    <xsd:element name="AlertVersion" type="xsd:int" minOccurs="0">
    </xsd:element>
    <xsd:element name="SortOrder" type="xsd:int" minOccurs="0">
    </xsd:element>
    <xsd:element name="ExtraLeftColumns" type="xsd:int" default="0" minOccurs="0">
    </xsd:element>
    <xsd:element name="ExtraRightColumns" type="xsd:int" default="0" minOccurs="0">
    </xsd:element>
    <xsd:element name="DeletedTitle" type="xsd:string" minOccurs="0" maxOccurs="unbounded">
    </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