QueryTable

QueryTable class

Represents QueryTable information.

class QueryTable;

Method	Description
getConnectionId()	Gets the connection id of the query table.
getExternalConnection()	Gets the relate external connection.
getName()	Gets the name of querytable.
getResultRange()	Gets the range of the result.
getPreserveFormatting()	Returns or sets the PreserveFormatting of the object.
setPreserveFormatting(boolean)	Returns or sets the PreserveFormatting of the object.
getAdjustColumnWidth()	Returns or sets the AdjustColumnWidth of the object.
setAdjustColumnWidth(boolean)	Returns or sets the AdjustColumnWidth of the object.
isNull()	Checks whether the implementation object is null.

Gets the connection id of the query table.

getConnectionId() : number;

Gets the relate external connection.

getExternalConnection() : ExternalConnection;

Returns

ExternalConnection

Gets the name of querytable.

getName() : string;

Gets the range of the result.

getResultRange() : Range;

Returns

Range

Returns or sets the PreserveFormatting of the object.

getPreserveFormatting() : boolean;

Returns or sets the PreserveFormatting of the object.

setPreserveFormatting(value: boolean) : void;

Parameters:

Parameter	Type	Description
value	boolean	The value to set.

Returns or sets the AdjustColumnWidth of the object.

getAdjustColumnWidth() : boolean;

Returns or sets the AdjustColumnWidth of the object.

setAdjustColumnWidth(value: boolean) : void;

Parameters:

Parameter	Type	Description
value	boolean	The value to set.

Checks whether the implementation object is null.

isNull() : boolean;