Class QueryTableImpl

Represents the Query table

Inheritance

System.Object

QueryTableImpl

Namespace: Syncfusion.XlsIO.Implementation

Assembly: Syncfusion.XlsIO.NET.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()