QueryTable
Contents
[
Hide
]QueryTable class
Represents QueryTable information.
class QueryTable;
Methods
| 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. |
getConnectionId()
Gets the connection id of the query table.
getConnectionId() : number;
getExternalConnection()
Gets the relate external connection.
getExternalConnection() : ExternalConnection;
Returns
getName()
Gets the name of querytable.
getName() : string;
getResultRange()
Gets the range of the result.
getResultRange() : Range;
Returns
getPreserveFormatting()
Returns or sets the PreserveFormatting of the object.
getPreserveFormatting() : boolean;
setPreserveFormatting(boolean)
Returns or sets the PreserveFormatting of the object.
setPreserveFormatting(value: boolean) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | boolean | The value to set. |
getAdjustColumnWidth()
Returns or sets the AdjustColumnWidth of the object.
getAdjustColumnWidth() : boolean;
setAdjustColumnWidth(boolean)
Returns or sets the AdjustColumnWidth of the object.
setAdjustColumnWidth(value: boolean) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | boolean | The value to set. |