Documentation for Microsoft Office 2003 Reference Schemas
Definition Type: ComplexType
Name: RefreshInfoType
Namespace: urn:schemas-microsoft-com:office:excel
Containing Schema: excel.xsd
Abstract
Documentation:
Contains information to be used when data is refreshed.
Collapse XSD Schema Diagram:
Drilldown into DeletedTitle in schema excel_xsd Drilldown into ExtraRightColumns in schema excel_xsd Drilldown into ExtraLeftColumns in schema excel_xsd Drilldown into SortOrder in schema excel_xsd Drilldown into AlertVersion in schema excel_xsd Drilldown into NoTitles in schema excel_xsd Drilldown into IdWrapped in schema excel_xsd Drilldown into HeaderRow in schema excel_xsd Drilldown into FuturePersist in schema excel_xsd Drilldown into CaseSensitive in schema excel_xsd Drilldown into Sort in schema excel_xsd Drilldown into DoNotPersstAF in schema excel_xsd Drilldown into DoNotPersistSort in schema excel_xsd Drilldown into DoNotPersist in schema excel_xsd Drilldown into ColumnInfo in schema excel_xsd Drilldown into NextId in schema excel_xsdXSD Diagram of RefreshInfoType in schema excel_xsd (Microsoft Office 2003 Reference Schemas)
Collapse XSD Schema Code: 
<xsd:complexType name="RefreshInfoType">
    <xsd:annotation>
        <xsd:documentation>Contains information to be used when data is refreshed.</xsd:documentation>
    </xsd:annotation>
    <xsd:sequence>
        <xsd:element name="NextId" type="xsd:integer">
            <xsd:annotation>
                <xsd:documentation>Specifies the next available unique identification number that can be assigned to a column.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="ColumnInfo" type="ColumnInfoType" minOccurs="0" maxOccurs="unbounded">
            <xsd:annotation>
                <xsd:documentation>Contains information about a column.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="DoNotPersist" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies whether to preserve sort and filter settings for a column.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="DoNotPersistSort" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies whether sort settings are preserved for a column.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="DoNotPersstAF" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies whether filter settings are preserved for a column.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="Sort" type="xsd:string" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies a range of cells or the name of a range to sort, or whether a query table has been sorted.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="CaseSensitive" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies whether sorting is case-sensitive.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="FuturePersist" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Reserved for future use.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="HeaderRow" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies whether the header row is included in a sort.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="IdWrapped" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies whether all possible identification numbers assigned to columns have been used and whether previously used numbers are being implemented.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="NoTitles" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies whether column titles are included in a query.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="AlertVersion" type="xsd:int" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Reserved for future use.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="SortOrder" type="xsd:int" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies the index number of a sort order used in a custom sort.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="ExtraLeftColumns" type="xsd:int" default="0" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies the number of columns to the left of a query table included in a sort.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="ExtraRightColumns" type="xsd:int" default="0" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies the number of columns to the right of a query table included in a sort.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="DeletedTitle" type="xsd:string" minOccurs="0" maxOccurs="unbounded">
            <xsd:annotation>
                <xsd:documentation>Contains the column title deleted from a query.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
    </xsd:sequence>
</xsd:complexType>
Collapse Child Elements:
Name Type Min Occurs Max Occurs
NextId x:NextId (1) (1)
ColumnInfo x:ColumnInfo 0 unbounded
DoNotPersist x:DoNotPersist 0 (1)
DoNotPersistSort x:DoNotPersistSort 0 (1)
DoNotPersstAF x:DoNotPersstAF 0 (1)
Sort x:Sort 0 (1)
CaseSensitive x:CaseSensitive 0 (1)
FuturePersist x:FuturePersist 0 (1)
HeaderRow x:HeaderRow 0 (1)
IdWrapped x:IdWrapped 0 (1)
NoTitles x:NoTitles 0 (1)
AlertVersion x:AlertVersion 0 (1)
SortOrder x:SortOrder 0 (1)
ExtraLeftColumns x:ExtraLeftColumns 0 (1)
ExtraRightColumns x:ExtraRightColumns 0 (1)
DeletedTitle x:DeletedTitle 0 unbounded
Collapse Derivation Tree:
Collapse References:
x:RefreshInfo, x:RefreshInfo
Documentation for Microsoft Office 2003 Reference Schemas

Generated using Liquid Studio - Developer Bundle 21.0.0.0