[ms-xlsx]: Excel (. xlsx) Extensions to the Office Open xml spreadsheetml file Format Intellectual Property Rights Notice for Open Specifications Documentation

1895.1.1CT_QueryTable

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

Referenced by: queryTable

A complex type that specifies extended properties of a query table ([ISO/IEC29500-1:2012] section 18.12).

Attributes:

clipped: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether a query table ([ISO/IEC29500-1:2012] section 18.12) did not fit to worksheet and was clipped.

Value	Meaning
"true"	A query table ([ISO/IEC29500-1:2012] section 18.12) did not fit to the worksheet and was clipped.
"false"	A query table ([ISO/IEC29500-1:2012] section 18.12) did not fit to the worksheet and was not clipped.

sourceDataName: A string ([XMLSCHEMA2] section 3.2.1) attribute that specifies the name of the primary data connection for the query table. For more details, see connection ([ISO/IEC29500-1:2012] section 18.13.1)

drillThrough: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether a query table ([ISO/IEC29500-1:2012] is a result of drillthrough operation on OLAP data source.

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

1896

1897

1898

1899

1900

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

1900.1.1CT_WebExtensions

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

Referenced by: webExtensions

A complex type that specifies a list of CT_WebExtension elements. The list of CT_WebExtension elements specifies all the bindings for web extensions, as specified by [MS-OWEXML] section 1.3, on the worksheet.

Child Elements:

webExtension: A CT_WebExtension element that specifies a binding for a web extension, as specified by [MS-OWEXML] section 1.3, on the worksheet.

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

1901

1902

1903

1904

1905

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

1905.1.1CT_WebExtension

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

Referenced by: CT_WebExtensions

A complex type that specifies a binding for a web extension, as specified by [MS-OWEXML] section 1.3, on the worksheet.

Child Elements:

xm:f: An f element that specifies the data range for the Binding. The formula MUST adhere to the grammar specified in Section Formulas, with the following restrictions:

• 
  MUST follow the ref-nospace-expression rule.
  
• 
  MUST NOT use the bang-reference, bang-name, sheet-range-reference, or local-cell-reference production rules.
  

Attributes:

appRef: An ST_Xstring ([ISO/IEC29500-1:2012] 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.

1906

1907

1908

1909

1910

1911

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

1911.1.1CT_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:2012] 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:2012].

Child Elements:

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

Attributes:

id: An ST_Xstring ([ISO/IEC29500-1:2012] 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] 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:2012] section A.2, MUST be equal to "5".

excludeFromRefreshAll: A Boolean ([XMLSCHEMA2] 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] 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] 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] section 2.1) fragment specifies the contents of this complex type.

1912

1913

1914

1915

1916

1917

1918

1919

1920

1921

1922

1923

1924

1925

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