XlTableReference(IXlTable, String) Constructor

Initializes a new instance of the XlTableReference class with the specified settings.

Namespace: DevExpress.Export.Xl

Assembly: DevExpress.Printing.v19.1.Core.dll

Declaration

C#

public XlTableReference(
    IXlTable table,
    string columnName
)

VB.NET

Public Sub New(
    table As IXlTable,
    columnName As String
)

Parameters

Name	Type	Description
table	IXlTable	An IXlTable object that specifies the referenced table.
columnName	String	A string that specifies the name of the column containing data to which the structured reference refers.

Remarks

Use this constructor to create a reference to the data range of the specified column (excluding the column header and total cells).

For example, the following code creates a reference to the data of the column”Q1”, which is the cell range B2:B5 (see the image below the code snippet).

C#

XlTableReference reference = new XlTableReference(table, "Q1");

VB.NET

Dim reference As New XlTableReference(table, "Q1")