2.1.7.24 External Data Connections

Artículo
05/17/2022

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