Share via

2.6.91 CT_Connection

  • Article

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2010/11/main

Referenced by: connection

A complex type that specifies the extended properties of an external connection ([ISO/IEC29500-1:2016] section 18.13). See section 2.2.4.1 for how this element integrates with the Office Open XML file formats specified in [ISO/IEC29500-1:2016].

Child Elements:

textPr: A CT_TextPr ([ISO/IEC29500-4:2016] section 18.13.12) element that specifies properties for data model data source text importation.

If this element is present, then the type attribute of the ancestor CT_Connection element, as specified in [ISO/IEC29500-4:2016] section A.2, MUST be equal to "103".

modelTextPr: A CT_ModelTextPr element that specifies a data model data source text importation ([MS-XLSB] section 2.2.8.9.4) properties in addition to those specified in textPr element.

If this element is present, then:

  • the type attribute of the ancestor CT_Connection element, as specified in [ISO/IEC29500-4:2016] section A.2, MUST be equal to "103".

  • Ancestor CT_Connection element MUST contain textPr element.

rangePr: A CT_RangePr element that specifies data model data source Worksheet Data connection ([MS-XLSB] section 2.2.8.9.3) properties.

If this element is present, then the type attribute of the ancestor CT_Connection element, as specified in [ISO/IEC29500-4:2016] section A.2, MUST be equal to "102".

oledbPr: A CT_OledbPr element that specifies data model data source OLE DB connection ([MS-XLSB] section 2.2.8.9.1) properties.

If this element is present, then the type attribute of the ancestor CT_Connection element, as specified in [ISO/IEC29500-4:2016] section A.2, MUST be equal to "100".

dataFeedPr: A CT_DataFeedPr element that specifies data model data source Data Feed connection ([MS-XLSB] section 2.2.8.9.2) properties.

If this element is present, then the type attribute of the ancestor CT_Connection element, as specified in [ISO/IEC29500-4:2016] section A.2, MUST be equal to "101".

Attributes:

id: An ST_Xstring ([ISO/IEC29500-1:2016] section 22.9.2.19) attribute that specifies the identifier of the Data Model data source. The string MUST be less than or equal to 65535 characters in length. The string length MUST be equal to zero characters if the model attribute equals "true".

model: A Boolean ([XMLSCHEMA2/2] section 3.2.2) attribute that specifies whether this connection is a connection to the spreadsheet data model. If this element equals "true", the type attribute of the ancestor CT_Connection element, as specified in [ISO/IEC29500-4:2016] section A.2, MUST be equal to "5".

excludeFromRefreshAll: A Boolean ([XMLSCHEMA2/2] section 3.2.2) attribute that specifies whether this connection is not to be refreshed on Refresh All.

Value

Meaning

"true"

This connection is not to be refreshed on Refresh All.

"false"

This connection is to be refreshed on Refresh All.

autoDelete: A Boolean ([XMLSCHEMA2/2] section 3.2.2) attribute that specifies whether this connection will be automatically deleted when all data features which use it are deleted.

Value

Meaning

"true"

This connection will be automatically deleted when all data features that use it are deleted.

"false"

This connection will not be automatically deleted when all data features that use it are deleted.

usedByAddin: A Boolean ([XMLSCHEMA2/2] section 3.2.2) attribute that specifies whether this connection is used by an addin component and will not be deleted with any data feature that uses it.

Value

Meaning

"true"

This connection is used by an addin component.

"false"

This connection is not used by an addin component.

The following W3C XML Schema ([XMLSCHEMA1/2] section 2.1) fragment specifies the contents of this complex type.

 <xsd:complexType name="CT_Connection">
   <xsd:sequence>
     <xsd:element name="textPr" minOccurs="0" maxOccurs="1" type="x:CT_TextPr"/>
     <xsd:element name="modelTextPr" minOccurs="0" maxOccurs="1" type="CT_ModelTextPr"/>
     <xsd:element name="rangePr" minOccurs="0" maxOccurs="1" type="CT_RangePr"/>
     <xsd:element name="oledbPr" minOccurs="0" maxOccurs="1" type="CT_OledbPr"/>
     <xsd:element name="dataFeedPr" minOccurs="0" maxOccurs="1" type="CT_DataFeedPr"/>
   </xsd:sequence>
   <xsd:attribute name="id" use="required" type="x:ST_Xstring"/>
   <xsd:attribute name="model" type="xsd:boolean" default="false" use="optional"/>
   <xsd:attribute name="excludeFromRefreshAll" type="xsd:boolean" default="false" use="optional"/>
   <xsd:attribute name="autoDelete" type="xsd:boolean" default="false" use="optional"/>
   <xsd:attribute name="usedByAddin" type="xsd:boolean" default="false" use="optional"/>
 </xsd:complexType>

See section 5.3 for the full W3C XML Schema ([XMLSCHEMA1/2] section 2.1).