XlTableReference Class

Represents a reference to table data.

Namespace: DevExpress.Export.Xl

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

Declaration

C#

public class XlTableReference :
    IXlFormulaParameter

VB.NET

Public Class XlTableReference
    Implements IXlFormulaParameter

Related API Members

The following members return XlTableReference objects:

• IXlTable.GetReference(XlTablePart, String, String)
• IXlTable.GetReference(XlTablePart, String)
• IXlTable.GetReference(XlTablePart)
• IXlTable.GetRowReference(String, String)
• IXlTable.GetRowReference(String)

Remarks

An instance of the XlTableReference class represents a structured reference that can be used to work with table data when you create formulas referencing a table or different ranges within a table. Refer to the How to: Create a Calculated Column topic for an example on how to use a structured reference to create a formula for a calculated table column.

Note that you can also use the IXlTable.GetReference or IXlTable.GetRowReference methods of a particular table to create structured references that refer to data within this table.

Implements

IXlFormulaParameter

Inheritance

Object

XlTableReference