Class QueryTableImpl
Represents the Query table
Inheritance
System.Object
QueryTableImpl
Namespace: Syncfusion.XlsIO.Implementation
Assembly: Syncfusion.XlsIO.Base.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
Gets or sets the Column width for QueryTable.
Declaration
public bool AdjustColumnWidth { get; set; }Property Value
| Type |
|---|
| System.Boolean |
BackgroundQuery
Gets or sets a value indicating whether the Query table is performed Asynchronously
Declaration
public bool BackgroundQuery { get; set; }Property Value
| Type |
|---|
| System.Boolean |
CommandText
Gets or sets the command string for the specified data source.
Declaration
public object CommandText { get; set; }Property Value
| Type |
|---|
| System.Object |
CommandType
Gets or sets the Command Type for specified connection.
Declaration
public ExcelCommandType CommandType { get; set; }Property Value
| Type |
|---|
| ExcelCommandType |
ConncetionId
Gets the connection ID. Read-Only
Declaration
public uint ConncetionId { get; }Property Value
| Type |
|---|
| System.UInt32 |
Remarks
This API is deprecated. Please use the ConnectionId instead.
ConnectionId
Gets the connection ID. Read-only
Declaration
public uint ConnectionId { get; }Property Value
| Type |
|---|
| System.UInt32 |
ConnectionString
Gets or sets connection information.
Declaration
public object ConnectionString { get; set; }Property Value
| Type |
|---|
| System.Object |
ExternalConnection
Gets the Connection for the Specified QueryTable.
Declaration
public ExternalConnection ExternalConnection { get; }Property Value
| Type |
|---|
| ExternalConnection |
Name
Gets or sets the Name of the Query Table.
Declaration
public string Name { get; set; }Property Value
| Type |
|---|
| System.String |
Parameters
Gets the parameter collection.
Declaration
public IParameters Parameters { get; }Property Value
| Type |
|---|
| IParameters |
RefreshOnFileOpen
Gets or sets a value indicating whether the Query Table is automatically updated when open the workbook.
Declaration
public bool RefreshOnFileOpen { get; set; }Property Value
| Type |
|---|
| System.Boolean |
Methods
Delete()
Delete the query table from the workbook
Declaration
public void Delete()