 | Query |
The QueryTable type exposes the following members.
Properties| Name | Description | |
|---|---|---|
 | AdjustColumnWidth | adjustColumnWidth Represents the following attribute in the schema: adjustColumnWidth |
| ApplyAlignmentFormats | Apply Alignment Formats Represents the following attribute in the schema: applyAlignmentFormats |
| ApplyBorderFormats | Apply Border Formats Represents the following attribute in the schema: applyBorderFormats |
| ApplyFontFormats | Apply Font Formats Represents the following attribute in the schema: applyFontFormats |
| ApplyNumberFormats | Apply Number Formats Represents the following attribute in the schema: applyNumberFormats |
| ApplyPatternFormats | Apply Pattern Formats Represents the following attribute in the schema: applyPatternFormats |
| ApplyWidthHeightFormats | Apply Width / Height Formats Represents the following attribute in the schema: applyWidthHeightFormats |
| AutoFormatId | Auto Format Id Represents the following attribute in the schema: autoFormatId |
| BackgroundRefresh | backgroundRefresh Represents the following attribute in the schema: backgroundRefresh |
| ChildElements |
Gets all the child nodes of the current element.
(Inherited from OpenXmlElement) |
| ConnectionId | connectionId Represents the following attribute in the schema: connectionId |
| DisableEdit | disableEdit Represents the following attribute in the schema: disableEdit |
| DisableRefresh | disableRefresh Represents the following attribute in the schema: disableRefresh |
| ExtendedAttributes |
Gets all extended attributes (attributes not defined in the schema) of the current element.
(Inherited from OpenXmlElement) |
| Features |
Gets a IFeatureCollection for the current element. This feature collection will be read-only, but will inherit features from its parent part and package if available.
(Inherited from OpenXmlElement) |
| FillFormulas | fillFormulas Represents the following attribute in the schema: fillFormulas |
| FirstBackgroundRefresh | firstBackgroundRefresh Represents the following attribute in the schema: firstBackgroundRefresh |
| FirstChild |
Gets the first child of the current OpenXmlElement element.
(Inherited from OpenXmlCompositeElement) |
| GrowShrinkType | growShrinkType Represents the following attribute in the schema: growShrinkType |
| HasAttributes |
Gets a value indicating whether the current element has any attributes.
(Inherited from OpenXmlElement) |
| HasChildren |
Gets a value indicating whether the current element has any child elements.
(Inherited from OpenXmlCompositeElement) |
| Headers | headers Represents the following attribute in the schema: headers |
| InnerText |
Gets or sets the concatenated values of the node and all of its children.
(Inherited from OpenXmlCompositeElement) |
| InnerXml |
Gets or sets the markup that represents only the child elements of the current element.
(Inherited from OpenXmlCompositeElement) |
| Intermediate | intermediate Represents the following attribute in the schema: intermediate |
| LastChild |
Gets the last child of the current OpenXmlElement element.
Returns null (Nothing in Visual Basic) if there is no such OpenXmlElement element.
(Inherited from OpenXmlCompositeElement) |
| LocalName |
Gets the local name of the current element.
(Inherited from OpenXmlElement) |
| MCAttributes |
Gets or sets the markup compatibility attributes. Returns null if no markup compatibility attributes are defined for the current element.
(Inherited from OpenXmlElement) |
| Name | name Represents the following attribute in the schema: name |
| NamespaceDeclarations |
Gets all the namespace declarations defined in the current element. Returns an empty enumerator if there is no namespace declaration.
(Inherited from OpenXmlElement) |
| NamespaceUri |
Gets the namespace URI of the current element.
(Inherited from OpenXmlElement) |
| OpenXmlElementContext |
Gets the OpenXmlElementContext of the current element.
(Inherited from OpenXmlElement) |
| OuterXml |
Gets the markup that represents the current element and all of its child elements.
(Inherited from OpenXmlElement) |
| Parent |
Gets the parent element of the current element.
(Inherited from OpenXmlElement) |
| Prefix |
Gets the namespace prefix of current element.
(Inherited from OpenXmlElement) |
| PreserveFormatting | preserveFormatting Represents the following attribute in the schema: preserveFormatting |
| QueryTableExtensionList | QueryTableExtensionList. Represents the following element tag in the schema: x:extLst. |
| QueryTablePart | Gets the QueryTablePart associated with this element. |
| QueryTableRefresh | QueryTableRefresh. Represents the following element tag in the schema: x:queryTableRefresh. |
| RefreshOnLoad | refreshOnLoad Represents the following attribute in the schema: refreshOnLoad |
| RemoveDataOnSave | removeDataOnSave Represents the following attribute in the schema: removeDataOnSave |
| RowNumbers | rowNumbers Represents the following attribute in the schema: rowNumbers |
| XmlQualifiedName |
Gets the qualified name of the current element.
(Inherited from OpenXmlElement) |
| XName |
Gets the qualified name of the current element.
(Inherited from OpenXmlElement) |
See Also