QueryTable Properties
Include Protected Members
Include Inherited Members
The QueryTable type exposes the following members.
Properties
| Name | Description | |
|---|---|---|
.gif "Public property") |
AdjustColumnWidth | Adjust Column Width On Refresh.Represents the attribte in schema: adjustColumnWidth |
|
ApplyAlignmentFormats | Apply Alignment Formats.Represents the attribte in schema: applyAlignmentFormats |
|
ApplyBorderFormats | Apply Border Formats.Represents the attribte in schema: applyBorderFormats |
|
ApplyFontFormats | Apply Font Formats.Represents the attribte in schema: applyFontFormats |
|
ApplyNumberFormats | Apply Number Formats.Represents the attribte in schema: applyNumberFormats |
|
ApplyPatternFormats | Apply Pattern Formats.Represents the attribte in schema: applyPatternFormats |
|
ApplyWidthHeightFormats | Apply Width / Height Formats.Represents the attribte in schema: applyWidthHeightFormats |
|
AutoFormatId | Auto Format Id.Represents the attribte in schema: autoFormatId |
|
BackgroundRefresh | Background Refresh.Represents the attribte in schema: backgroundRefresh |
|
ChildElements | Gets all the child nodes of this element. (Inherited from OpenXmlElement.) |
|
ConnectionId | Connection Id.Represents the attribte in schema: connectionId |
|
DisableEdit | Disable Edit.Represents the attribte in schema: disableEdit |
|
DisableRefresh | Disable Refresh.Represents the attribte in schema: disableRefresh |
|
ExtendedAttributes | Gets all extended attributes (attributes not defined in schema) of the element. (Inherited from OpenXmlElement.) |
|
ExtensionList | Future Feature Data Storage Area.Represents the element tag in schema: x:extLst |
|
FillFormulas | Fill Adjacent Formulas.Represents the attribte in schema: fillFormulas |
|
FirstBackgroundRefresh | First Background Refresh.Represents the attribte in schema: firstBackgroundRefresh |
|
FirstChild | Gets the first child of the OpenXmlElement. If there is no such OpenXmlElement, a null reference (Nothing in Visual Basic) is returned. (Inherited from OpenXmlCompositeElement.) |
|
GrowShrinkType | Grow Shrink Type.Represents the attribte in schema: growShrinkType |
|
HasAttributes | Gets a boolean value indicating whether the current element has any attributes. (Inherited from OpenXmlElement.) |
|
HasChildren | Gets a value indicating whether this element has any child elements. (Inherited from OpenXmlCompositeElement.) |
|
Headers | First Row Column Titles.Represents the attribte in schema: headers |
|
InnerText | Gets or sets the concatenated values of the node and all its children. (Inherited from OpenXmlCompositeElement.) |
|
InnerXml | Gets or sets the markup representing only the child nodes of this node. (Inherited from OpenXmlCompositeElement.) |
|
Intermediate | Intermediate.Represents the attribte in schema: intermediate |
|
LastChild | Gets the last child of the OpenXmlElement. If there is no such OpenXmlElement, a null reference (Nothing in Visual Basic) is returned. (Inherited from OpenXmlCompositeElement.) |
|
LocalName | Gets the local name of the element. (Overrides OpenXmlElement.LocalName.) |
|
MCAttributes | Markup Compatibility Attributes Set. Return null if there is no Markup Compatibility Attribute defined in this element. (Inherited from OpenXmlElement.) |
|
Name | QueryTable Name.Represents the attribte in schema: name |
|
NamespaceDeclarations | Gets all the namespace declarations defined in the current element. Return an empty enumerator if there is no namespace declaration. (Inherited from OpenXmlElement.) |
|
NamespaceUri | Gets the namespace URI of this node. (Inherited from OpenXmlElement.) |
|
OpenXmlElementContext | Gets the OpenXmlEementContext. (Inherited from OpenXmlElement.) |
|
OuterXml | Gets the markup representing this element and all its child elements. (Inherited from OpenXmlElement.) |
|
Parent | Gets the parent of this element. (Inherited from OpenXmlElement.) |
|
Prefix | Gets the namespace prefix of this node. (Inherited from OpenXmlElement.) |
|
PreserveFormatting | Preserve Formatting On Refresh.Represents the attribte in schema: preserveFormatting |
|
QueryTablePart | Gets the QueryTablePart associated with this element. |
|
QueryTableRefresh | QueryTable Refresh Information.Represents the element tag in schema: x:queryTableRefresh |
|
RefreshOnLoad | Refresh On Load.Represents the attribte in schema: refreshOnLoad |
|
RemoveDataOnSave | Remove Data On Save.Represents the attribte in schema: removeDataOnSave |
|
RowNumbers | Row Numbers.Represents the attribte in schema: rowNumbers |
|
XmlQualifiedName | Gets the qualified name of the node. (Inherited from OpenXmlElement.) |
Top