QueryTable

QueryTable class

Represents QueryTable information.

Properties

NameTypeDescription
ConnectionIdNumberGets the connection id of the query table.
ExternalConnectionExternalConnectionGets the relate external connection.
NameStringGets the name of querytable.
ResultRangeRangeGets the range of the result.
PreserveFormattingbooleanReturns or sets the PreserveFormatting of the object.
AdjustColumnWidthbooleanReturns or sets the AdjustColumnWidth of the object.

QueryTable.ConnectionId property

Gets the connection id of the query table.

Type: Number

QueryTable.ExternalConnection property

Gets the relate external connection.

Type: ExternalConnection

QueryTable.Name property

Gets the name of querytable.

Type: String

QueryTable.ResultRange property

Gets the range of the result.

Type: Range

QueryTable.PreserveFormatting property

Returns or sets the PreserveFormatting of the object.

Type: boolean

QueryTable.AdjustColumnWidth property

Returns or sets the AdjustColumnWidth of the object.

Type: boolean