Class QueryTableImpl
Represents the Query table
Inheritance
System.Object
QueryTableImpl
Namespace: Syncfusion.XlsIO.Implementation
Assembly: Syncfusion.XlsIO.Portable.dll
Syntax
public class QueryTableImpl : ObjectConstructors
QueryTableImpl(IApplication, Object, ExternalConnection)
Query table implementation
Declaration
public QueryTableImpl(IApplication application, object parent, ExternalConnection ExternalConnection)Parameters
| Type | Name | Description |
|---|---|---|
| IApplication | application | |
| System.Object | parent | |
| ExternalConnection | ExternalConnection |
Properties
AdjustColumnWidth
Represent the Column width for QueryTable
Declaration
public bool AdjustColumnWidth { get; set; }Property Value
| Type | Description |
|---|---|
| System.Boolean |
BackgroundQuery
Query table performed Asynchronously
Declaration
public bool BackgroundQuery { get; set; }Property Value
| Type | Description |
|---|---|
| System.Boolean |
CommandText
Represent the command string for the specified data source
Declaration
public object CommandText { get; set; }Property Value
| Type | Description |
|---|---|
| System.Object |
CommandType
Command Type for specified connection
Declaration
public ExcelCommandType CommandType { get; set; }Property Value
| Type | Description |
|---|---|
| ExcelCommandType |
ConncetionId
Represent the connection ID-Read-Only
Declaration
public uint ConncetionId { get; }Property Value
| Type | Description |
|---|---|
| System.UInt32 |
ConnectionString
Define connection information
Declaration
public object ConnectionString { get; set; }Property Value
| Type | Description |
|---|---|
| System.Object |
ExternalConnection
Represent the Connection for the Specified QueryTable
Declaration
public ExternalConnection ExternalConnection { get; }Property Value
| Type | Description |
|---|---|
| ExternalConnection |
Name
Represent the Name of the Query Table
Declaration
public string Name { get; set; }Property Value
| Type | Description |
|---|---|
| System.String |
Parameters
Represent the parameter collection.
Declaration
public IParameters Parameters { get; }Property Value
| Type | Description |
|---|---|
| IParameters |
RefreshOnFileOpen
The Query Table is automatically updated when open the workbook
Declaration
public bool RefreshOnFileOpen { get; set; }Property Value
| Type | Description |
|---|---|
| System.Boolean |
Methods
Delete()
Delete the query table from this object
Declaration
public void Delete()