2.1.7.24 External Data Connections

An instance of the External Data Connections part type specifies external connections (section 2.2.8) for the workbook.

Content type: application/vnd.ms-excel.connections

Source relationship: http://schemas.openxmlformats.org/officeDocument/2006/relationships/connections

A package MUST contain at most one External Data Connections part, which MUST be the target of an implicit relationship from the workbook (section 2.1.7.61) part.

An External Data Connections part MUST NOT have implicit or explicit relationships to any part specified by this document.

Record sequence ABNF:

EXTCONNECTIONS = BrtBeginExtConnections 1*EXTCONNECTION BrtEndExtConnections

EXTCONNECTION = BrtBeginExtConnection [ACUID] [(ECDBPROPS [ECOLAPPROPS / ECPARAMS]) / (ECWEBPROPS [ECPARAMS]) / ECTXTWIZ] FRTEXTCONNECTIONS BrtEndExtConnection

ECDBPROPS = BrtBeginECDbProps BrtEndECDbProps

ECOLAPPROPS = BrtBeginECOlapProps BrtEndECOlapProps

ECWEBPROPS = BrtBeginECWebProps [ECWPTABLES] BrtEndECWebProps

ECWPTABLES = BrtBeginEcWpTables *PCDI BrtEndECWPTables

PCDI = BrtPCDIMissing / BrtPCDIIndex / BrtPCDIString

ECTXTWIZ = BrtBeginECTxtWiz ECTWFLDINFOLST BrtEndECTxtWiz

ECTWFLDINFOLST = BrtBeginECTWFldInfoLst 1*BrtBeginECTwFldInfo BrtEndECTWFldInfoLst

ECPARAMS = BrtBeginECParams 1*ECPARAM BrtEndECParams

ECPARAM = BrtBeginECParam BrtEndECParam

FRTEXTCONNECTIONS = [BrtFRTBegin [EXTCONN14] [EXTCONN15] BrtFRTEnd] *FRT

EXTCONN14 = BrtBeginExtConn14 [PCDCALCMEMSEXT] BrtEndExtConn14

EXTCONN15 = BrtBeginExtConn15 [OLEDBPR15 / DATAFEEDPR15 / TEXTPR15 / BrtRangePr15] BrtEndExtConn15

OLEDBPR15 = BrtBeginOledbPr15 (DBTABLES15 / BrtDbCommand15) BrtEndOledbPr15

DBTABLES15 = BrtBeginDbTables15 1*BrtDbTable15 BrtEndDbTables15

DATAFEEDPR15 = BrtBeginDataFeedPr15 DBTABLES15 BrtEndDataFeedPr15

TEXTPR15 = ECTXTWIZ15 [BrtTextPr15]

ECTXTWIZ15 = BrtBeginECTxtWiz15 ECTWFLDINFOLST15 BrtEndECTxtWiz15

ECTWFLDINFOLST15 = BrtBeginECTWFldInfoLst15 1*BrtBeginECTwFldInfo15 BrtEndECTWFldInfoLst15

For ABNF rules not listed here, see section 2.1.8.