QueryTable

QueryTable class

Represents QueryTable information.

public class QueryTable

Properties

Name Description
AdjustColumnWidth { get; set; } Returns or sets the AdjustColumnWidth of the object.
ConnectionId { get; } Gets the connection id of the query table.
ExternalConnection { get; } Gets the relate external connection.
Name { get; } Gets the name of querytable.
PreserveFormatting { get; set; } Returns or sets the PreserveFormatting of the object.
ResultRange { get; } Gets the range of the result.

Examples


[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
QueryTable qt = worksheet.QueryTables[0];
//Getting display address of the query table.
string address = qt.ResultRange.Address;

[VB.NET]

'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;

See Also

ProtectionType QueryTableCollection