Contains information to be used when data is refreshed.
Namespace | urn:schemas-microsoft-com:office:excel |
Schema name | XML Spreadsheet 2000 |
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. |
None.
<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>