Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

QueryTable class

Office 2013

Defines the QueryTable Class.This class is only available in Office2013. When the object is serialized out as xml, its qualified name is x15:queryTable.

Namespace:  DocumentFormat.OpenXml.Office2013.Excel
Assembly:  DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)

[OfficeAvailabilityAttribute(FileFormatVersions.Office2013)]
public class QueryTable : OpenXmlLeafElement

2.4.41 queryTable

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

A CT_QueryTable element that specifies extended properties of a query table ([ISO/IEC-29500-1] section 18.12).<18>

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

<xsd:element name="queryTable" type="CT_QueryTable"/>

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

2.6.88 CT_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/IEC-29500-1] section 18.12).<64>

Attributes:

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

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

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

<xsd:complexType name="CT_QueryTable">

<xsd:attribute name="clipped" use="optional" default="false" type="xsd:boolean"/>

<xsd:attribute name="sourceDataName" type="xsd:string" use="optional"/>

</xsd:complexType>

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

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Show:
© 2015 Microsoft