menu

Xamarin.Forms

  • Code Examples
  • Upgrade Guide
  • User Guide
  • Demos
  • Support
  • Forums
  • Download
Class QueryTableImpl - Xamarin.Forms API Reference | Syncfusion

    Show / Hide Table of Contents

    Class QueryTableImpl

    Represents the Query table

    Inheritance
    System.Object
    QueryTableImpl
    Namespace: Syncfusion.XlsIO.Implementation
    Assembly: Syncfusion.XlsIO.Portable.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()
    Back to top Generated by DocFX
    Copyright © 2001 - 2025 Syncfusion Inc. All Rights Reserved