AssociatedDataTable Property

Gets the data table to which the cell belongs.

Syntax

Visual Basic

'Declaration
 
Public ReadOnly Property AssociatedDataTable As WorksheetDataTable

C#

public WorksheetDataTable AssociatedDataTable {get;}

Property Value

The data table to which the cell belongs or null if the cell does not belong to a data table.

Remarks

The cells in the left-most column and top-most row of the data table will return null for the associated data table.

If a data table is associated with the cell, getting the Value will return the calculated value for the cell.

Note: it is slightly faster to use the WorksheetRow.GetCellAssociatedDataTable method, which does not create a WorksheetCell instance internally. However, if a reference to the WorksheetCell instance already exists, using this property is equivalent to using the WorksheetRow.GetCellAssociatedDataTable method.

Requirements

Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Server 2012, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2