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.

Methods

MethodDescription
getConnectionId()@deprecated. Please use the ‘connectionId’ property instead. Gets the connection id of the query table.
getExternalConnection()@deprecated. Please use the ’externalConnection’ property instead. Gets the relate external connection.
getName()@deprecated. Please use the ’name’ property instead. Gets the name of querytable.
getResultRange()@deprecated. Please use the ‘resultRange’ property instead. Gets the range of the result.
getPreserveFormatting()@deprecated. Please use the ‘preserveFormatting’ property instead. Returns or sets the PreserveFormatting of the object.
setPreserveFormatting(boolean)@deprecated. Please use the ‘preserveFormatting’ property instead. Returns or sets the PreserveFormatting of the object.
getAdjustColumnWidth()@deprecated. Please use the ‘adjustColumnWidth’ property instead. Returns or sets the AdjustColumnWidth of the object.
setAdjustColumnWidth(boolean)@deprecated. Please use the ‘adjustColumnWidth’ property instead. Returns or sets the AdjustColumnWidth of the object.
isNull()Checks whether the implementation object is null.

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;

getConnectionId()

@deprecated. Please use the ‘connectionId’ property instead. Gets the connection id of the query table.

getConnectionId() : number;

getExternalConnection()

@deprecated. Please use the ’externalConnection’ property instead. Gets the relate external connection.

getExternalConnection() : ExternalConnection;

Returns

ExternalConnection

getName()

@deprecated. Please use the ’name’ property instead. Gets the name of querytable.

getName() : string;

getResultRange()

@deprecated. Please use the ‘resultRange’ property instead. Gets the range of the result.

getResultRange() : Range;

Returns

Range

getPreserveFormatting()

@deprecated. Please use the ‘preserveFormatting’ property instead. Returns or sets the PreserveFormatting of the object.

getPreserveFormatting() : boolean;

setPreserveFormatting(boolean)

@deprecated. Please use the ‘preserveFormatting’ property instead. Returns or sets the PreserveFormatting of the object.

setPreserveFormatting(value: boolean) : void;

Parameters:

ParameterTypeDescription
valuebooleanThe value to set.

getAdjustColumnWidth()

@deprecated. Please use the ‘adjustColumnWidth’ property instead. Returns or sets the AdjustColumnWidth of the object.

getAdjustColumnWidth() : boolean;

setAdjustColumnWidth(boolean)

@deprecated. Please use the ‘adjustColumnWidth’ property instead. Returns or sets the AdjustColumnWidth of the object.

setAdjustColumnWidth(value: boolean) : void;

Parameters:

ParameterTypeDescription
valuebooleanThe value to set.

isNull()

Checks whether the implementation object is null.

isNull() : boolean;