QueryTable
QueryTable class
Represents QueryTable information.
class QueryTable;
Properties
Property | Type | Description |
---|---|---|
connectionId | number | Readonly. Gets the connection id of the query table. |
externalConnection | ExternalConnection | Readonly. Gets the relate external connection. |
name | string | Readonly. Gets the name of querytable. |
resultRange | Range | Readonly. Gets the range of the result. |
preserveFormatting | boolean | Returns or sets the PreserveFormatting of the object. |
adjustColumnWidth | boolean | Returns or sets the AdjustColumnWidth of the object. |
Methods
Method | Description |
---|---|
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
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
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:
Parameter | Type | Description |
---|---|---|
value | boolean | The 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:
Parameter | Type | Description |
---|---|---|
value | boolean | The value to set. |
isNull()
Checks whether the implementation object is null.
isNull() : boolean;