IXlTable.GetReference(XlTablePart, String) Method

Returns a reference to the specified part of the table column.

Namespace: DevExpress.Export.Xl

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

NuGet Package: DevExpress.Printing.Core

Declaration

C#

XlTableReference GetReference(
    XlTablePart part,
    string columnName
)

VB.NET

Function GetReference(
    part As XlTablePart,
    columnName As String
) As XlTableReference

Parameters

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

Returns

Type	Description
XlTableReference	An XlTableReference object that specifies the created reference.

Remarks

Use this method 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 = table.GetReference(XlTablePart.Headers, "Q1");

VB.NET

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