Connection Class
Defines the Connection Class.This class is only available in Office2010.When the object is serialized out as xml, its qualified name is x14:connection.
Inheritance Hierarchy
System.Object
DocumentFormat.OpenXml.OpenXmlElement
DocumentFormat.OpenXml.OpenXmlCompositeElement
DocumentFormat.OpenXml.Office2010.Excel.Connection
Namespace: DocumentFormat.OpenXml.Office2010.Excel
Assembly: DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)
Syntax
'Declaration
<ChildElementInfoAttribute(GetType(CalculatedMembers), FileFormatVersions.Office2010)> _
<OfficeAvailabilityAttribute(FileFormatVersions.Office2010)> _
Public Class Connection _
Inherits OpenXmlCompositeElement
'Usage
Dim instance As Connection
[ChildElementInfoAttribute(typeof(CalculatedMembers), FileFormatVersions.Office2010)]
[OfficeAvailabilityAttribute(FileFormatVersions.Office2010)]
public class Connection : OpenXmlCompositeElement
Remarks
The following table lists the possible child types:
- CalculatedMembers <x14:calculatedMembers>
2.4.19 connection
Target namespace: https://schemas.microsoft.com/office/spreadsheetml/2010/main
A CT_Connection element that specifies the extended properties of an external connection ([ISO/IEC-29500-1] section 18.13). If this element exists, the type attribute of the ancestor CT_Connection ([ISO/IEC-29500-4] section A.2) element MUST be equal to 5. See Connections under Extensions by Part for how this element integrates with [ISO/IEC-29500-1].
The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this element.
<xsd:element name="connection" type="CT_Connection"/>
See section 5.3 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).
2.6.34 CT_Connection
Target namespace: https://schemas.microsoft.com/office/spreadsheetml/2010/main
Referenced by: connection
A complex type that specifies the extended properties of an external connection ([ISO/IEC-29500-1] section 18.13).
Child Elements:
calculatedMembers : A CT_CalculatedMembers ([ISO/IEC-29500-4] section A.2) element that specifies a list of PivotTable ([ISO/IEC-29500-1] section 18.10) OLAP calculated members associated with this external connection ([ISO/IEC-29500-1] section 18.13). If this external connection ([ISO/IEC-29500-1] section 18.13) is associated with a PivotTable ([ISO/IEC-29500-1] section 18.10) PivotCache, the list MUST NOT exist. If this element exists, the ancestor CT_connection ([ISO/IEC-29500-4] section A.2) element of this element MUST have a child CT_OlapPr ([ISO/IEC-29500-1] section 18.13.5) element.
Attributes:
lcid : An unsignedInt ([XMLSCHEMA2] section 3.3.22) attribute that specifies the language associated with this external connection ([ISO/IEC-29500-1] section 18.13).<32>
culture : An ST_Xstring ([ISO/IEC-29500-1] section 22.9.2.19) attribute that specifies the language associated with this external connection ([ISO/IEC-29500-1] section 18.13). The length of this string MUST be less than 85 characters. If the length of this string is greater than 0, the contents of this string MUST<33> be a language tag as specified by [RFC3066]. If this attribute is not present, the data connection is using the server language.<34>
embeddedDataId : An ST_Xstring ([ISO/IEC-29500-1] section 22.9.2.19) attribute that specifies an embedded Custom Data part. The length of this value MUST be less than 65536 characters. If the length of this string is greater than 0, the contents of this string MUST be equal to the id attribute of a CT_DatastoreItem element, in a Custom Data Properties part in this package ([ISO/IEC-29500-1] section 9).
The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this complex type.
<xsd:complexType name="CT_Connection">
<xsd:sequence>
<xsd:element name="calculatedMembers" type="x:CT_CalculatedMembers" minOccurs="0" maxOccurs="1"/>
</xsd:sequence>
<xsd:attribute name="lcid" use="optional" type="xsd:unsignedInt" default="0"/>
<xsd:attribute name="culture" use="optional" type="x:ST_Xstring"/>
<xsd:attribute name="embeddedDataId" use="optional" type="x:ST_Xstring"/>
</xsd:complexType>
See section 5.3 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).
Thread Safety
Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.