QueryTable

QueryTable class

Represents QueryTable information.

class QueryTable;

Properties

PropertyTypeDescription
connectionIdnumberReadonly. Gets the connection id of the query table.
externalConnectionExternalConnectionReadonly. Gets the relate external connection.
namestringReadonly. Gets the name of querytable.
resultRangeRangeReadonly. Gets the range of the result.
preserveFormattingbooleanReturns or sets the PreserveFormatting of the object.
adjustColumnWidthbooleanReturns or sets the AdjustColumnWidth of the object.

connectionId

Readonly. Gets the connection id of the query table.

connectionId : number;

externalConnection

Readonly. Gets the relate external connection.

externalConnection : ExternalConnection;

name

Readonly. Gets the name of querytable.

name : string;

resultRange

Readonly. Gets the range of the result.

resultRange : Range;

preserveFormatting

Returns or sets the PreserveFormatting of the object.

preserveFormatting : boolean;

adjustColumnWidth

Returns or sets the AdjustColumnWidth of the object.

adjustColumnWidth : boolean;