| Application
|
Returns the application associated with the query. Return value:
Application. This property is read only.
|
| BackgroundQuery
|
Return value: Boolean. This property is read only.
|
| ColumnDecreasedAction
|
Return/assignment value:
QueryDataDecreasedAction.
|
| ColumnIncreasedAction
|
Return/assignment value:
QueryDataIncreasedAction.
|
| ColumnNamePlacement
|
Return/assignment value:
QueryColumnNamePlacement.
|
| CommandText
|
Returns/sets the command text of a query. Return/assignment value: String.
|
| Connection
|
Returns/sets the connection string of a query. Return/assignment value: Variant.
|
| ContentData
|
Return/assignment value: Variant.
|
| DestinationCase
|
Returns/sets the spreadsheet case which the query will be written to. Return/assignment value: Integer.
|
| DestinationVariable
|
Returns/sets the spreadsheet variable which the query will be written to. Return/assignment value: Integer.
|
| Editable
|
Returns/sets whether the query is editable. Return value: Boolean. This property is read only.
|
| FetchedRowCount
|
Returns the number of rows that has been fetched so far. Return value: Integer. This property is read only.
|
| FitSpreadsheet
|
Sets if the query takes over its spreadsheet. Return/assignment value: Boolean.
|
| FormatTextColumnAsText
|
Return/assignment value: Boolean.
|
| FormatVariable
|
Return/assignment value: Boolean.
|
| FormatVariantColumnAsText
|
Return/assignment value: Boolean.
|
| IncludeRowNumber
|
Return/assignment value: Boolean.
|
| MaxRow
|
Returns/sets the maximum number of rows that the query may return. Return/assignment value: Integer.
|
| Name
|
Returns/sets the name of a query. Return/assignment value: String.
|
| OleColumnMaxSize
|
Maximum size of Ole columns. Return/assignment value: Integer.
|
| Parent
|
Returns the spreadsheet associated with the query. Return value:
Spreadsheet. This property is read only.
|
| Provider
|
Returns/sets the ADO.NET provider of a query. Return/assignment value: String.
|
| QueryTimeOut
|
Return/assignment value: Integer.
|
| Refreshing
|
Returns whether the query is refreshing. Return value: Boolean. This property is read only.
|
| RowDecreasedAction
|
Return/assignment value:
QueryDataDecreasedAction.
|
| RowIncreasedAction
|
Return/assignment value:
QueryDataIncreasedAction.
|
| TextColumnMaxSize
|
Maximum size of text columns. Return/assignment value: Integer.
|
| TreatQueryTextAsStoredProcedure
|
Return/assignment value: Boolean.
|
