aspose.cells

Classes

Constants

Class QueryTable

Represents QueryTable information.

Property Getters/Setters Summary
`function`	`getAdjustColumnWidth()`
`function`	`setAdjustColumnWidth(value)`
	Returns or sets the AdjustColumnWidth of the object.
`function`	`getConnectionId()`
	Gets the connection id of the query table.
`function`	`getExternalConnection()`
	Gets the relate external connection.
`function`	`getName()`
	Gets the name of querytable.
`function`	`getPreserveFormatting()`
`function`	`setPreserveFormatting(value)`
	Returns or sets the PreserveFormatting of the object.
`function`	`getResultRange()`
	Gets the range of the result.

- Property Getters/Setters Detail
  - getConnectionId : Number
```
function getConnectionId()
```
    Gets the connection id of the query table.
  - getExternalConnection : ExternalConnection
```
function getExternalConnection()
```
    Gets the relate external connection.
  - getName : String
```
function getName()
```
    Gets the name of querytable.
  - getResultRange : Range
```
function getResultRange()
```
    Gets the range of the result.
    Returns:
  - getPreserveFormatting/setPreserveFormatting : boolean
```
function getPreserveFormatting() / function setPreserveFormatting(value)
```
    Returns or sets the PreserveFormatting of the object.
  - getAdjustColumnWidth/setAdjustColumnWidth : boolean
```
function getAdjustColumnWidth() / function setAdjustColumnWidth(value)
```
    Returns or sets the AdjustColumnWidth of the object.