[ms-xlsx]: Excel (. xlsx) Extensions to the Office Open xml spreadsheetml file Format

appRef: An ST_Xstring ([ISO/IEC29500-1:2011] section 22.9.2.19) attribute that specifies a unique identifier for a binding for a web extension. This value MUST be equal to the appref field of a CT_OsfWebExtensionBinding element as specified by [MS-OWEXML] section 2.2.3.

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

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

2.6.91 CT_Connection

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:2011] 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:2011].

Child Elements:

textPr: A CT_TextPr ([ISO/IEC29500-4:2011] 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:2011] 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:2011] 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:2011] 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:2011] 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:2011] section A.2, MUST be equal to "101".

Attributes: