Class QueryTable
Represents a query table that connects to external data.
Inherited Members
Namespace: DRIT.Spreadsheet.Data
Assembly: DRIT.Spreadsheet.dll
Syntax
public class QueryTable
Constructors
QueryTable()
Initializes a new instance of the QueryTable class.
Declaration
public QueryTable()
QueryTable(string, DataConnection)
Initializes a new instance of the QueryTable class with a name and connection.
Declaration
public QueryTable(string name, DataConnection connection)
Parameters
| Type | Name | Description |
|---|---|---|
| string | name | The name of the query table. |
| DataConnection | connection | The data connection. |
Properties
AdjustColumnWidth
Gets or sets whether to adjust column width.
Declaration
public bool AdjustColumnWidth { get; set; }
Property Value
| Type | Description |
|---|---|
| bool |
BackgroundRefresh
Gets or sets whether to refresh in the background.
Declaration
public bool BackgroundRefresh { get; set; }
Property Value
| Type | Description |
|---|---|
| bool |
Connection
Specifies the data connection for the query table.
Declaration
public DataConnection Connection { get; set; }
Property Value
| Type | Description |
|---|---|
| DataConnection |
DisableEdit
Gets or sets whether editing is disabled.
Declaration
public bool DisableEdit { get; set; }
Property Value
| Type | Description |
|---|---|
| bool |
FillFormulas
Gets or sets whether to fill formulas.
Declaration
public bool FillFormulas { get; set; }
Property Value
| Type | Description |
|---|---|
| bool |
FirstBackgroundRefresh
Gets or sets whether this is the first background refresh.
Declaration
public bool FirstBackgroundRefresh { get; set; }
Property Value
| Type | Description |
|---|---|
| bool |
GrowShrinkType
Specifies the grow/shrink type for the query table.
Declaration
public GrowShrinkType GrowShrinkType { get; set; }
Property Value
| Type | Description |
|---|---|
| GrowShrinkType |
Headers
Gets or sets whether the first row of the query table contains headers.
Declaration
public bool Headers { get; set; }
Property Value
| Type | Description |
|---|---|
| bool |
Intermediate
Gets or sets whether this is an intermediate query table.
Declaration
public bool Intermediate { get; set; }
Property Value
| Type | Description |
|---|---|
| bool |
Name
Specifies the name of the query table.
Declaration
public string Name { get; set; }
Property Value
| Type | Description |
|---|---|
| string |
PreserveFormatting
Gets or sets whether to preserve formatting.
Declaration
public bool PreserveFormatting { get; set; }
Property Value
| Type | Description |
|---|---|
| bool |
Refresh
Gets the refresh settings for the query table.
Declaration
public QueryTableRefresh Refresh { get; }
Property Value
| Type | Description |
|---|---|
| QueryTableRefresh |
RefreshDisabled
Gets or sets whether refresh is disabled.
Declaration
public bool RefreshDisabled { get; set; }
Property Value
| Type | Description |
|---|---|
| bool |
RefreshOnLoad
Gets or sets whether to refresh on load.
Declaration
public bool RefreshOnLoad { get; set; }
Property Value
| Type | Description |
|---|---|
| bool |
RemoveDataOnSave
Gets or sets whether to remove data on save.
Declaration
public bool RemoveDataOnSave { get; set; }
Property Value
| Type | Description |
|---|---|
| bool |
RowNumbers
Gets or sets whether to show row numbers.
Declaration
public bool RowNumbers { get; set; }
Property Value
| Type | Description |
|---|---|
| bool |