Class QueryTableImpl

Represents the Query table

Inheritance
System.Object
QueryTableImpl
Namespace: Syncfusion.XlsIO.Implementation
Assembly: Syncfusion.XlsIO.UWP.dll
Syntax
public class QueryTableImpl : Object

Constructors

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()

Extension Methods