XlTableReference(IXlTable, String, XlTablePart) Constructor

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

Namespace: DevExpress.Export.Xl

Assembly: DevExpress.Printing.v24.2.Core.dll

Declaration

C#

public XlTableReference(
    IXlTable table,
    string columnName,
    XlTablePart part
)

VB.NET

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

Parameters

Name	Type	Description
table	IXlTable	An IXlTable object that specifies the referenced table.
columnName	String	A string that is the name of the column to the specified portion of which the structured reference refers.
part	XlTablePart	An XlTablePart enumeration member that specifies the part of the table column to use in the reference.

Remarks

Use this constructor to create a reference to a specific part of a table column.

For example, the following code creates a reference to the header row cell of the column”Q1”, which is the cell B1 (see the image below the code snippet).

C#

XlTableReference reference = new XlTableReference(table, "Q1", XlTablePart.Headers);

VB.NET

Dim reference As New XlTableReference(table, "Q1", XlTablePart.Headers)