Class QueryTable
Class QueryTable
Namespace: Aspose.Cells
Assembly: Aspose.Cells.dll (25.2.0)
Represents QueryTable information.
public class QueryTableInheritance
Inherited Members
object.GetType(), object.MemberwiseClone(), object.ToString(), object.Equals(object?), object.Equals(object?, object?), object.ReferenceEquals(object?, object?), object.GetHashCode()
Examples
csharp
[C#]
//Instantiating a Workbook object
Workbook workbook = new Workbook();
//Obtaining the reference of the first worksheet
Worksheet worksheet = workbook.Worksheets[0];
//Getting the first query table in the worksheet if exists
//QueryTable qt = worksheet.QueryTables[0];
//Getting display address of the query table.
//string address = qt.ResultRange.Address;
'Instantiating a Workbook object
Dim workbook As Workbook = New Workbook()
'Obtaining the reference of the first worksheet
Dim worksheet As Worksheet = workbook.Worksheets(0)
'Getting the first query table in the worksheet
QueryTable qt = worksheet.QueryTables[0];
'Getting display address of the query table.
string address = qt.ResultRange.Address;Properties
AdjustColumnWidth
Returns or sets the AdjustColumnWidth of the object.
public bool AdjustColumnWidth { get; set; }Property Value
ConnectionId
Gets the connection id of the query table.
public int ConnectionId { get; }Property Value
ExternalConnection
Gets the relate external connection.
public ExternalConnection ExternalConnection { get; }Property Value
Name
Gets the name of querytable.
public string Name { get; }Property Value
PreserveFormatting
Returns or sets the PreserveFormatting of the object.
public bool PreserveFormatting { get; set; }Property Value
ResultRange
Gets the range of the result.
public Range ResultRange { get; }