AssociatedDataTable Property

'Declaration
 
Public ReadOnly Property AssociatedDataTable As WorksheetDataTable

public WorksheetDataTable AssociatedDataTable {get;}

Property Value

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.

Target Platforms: Windows 8.1, Windows 8.1, Windows 8, Windows 7, 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

Reference

WorksheetCell Class
WorksheetCell Members
DataTables Property
Add Method
GetCellAssociatedDataTable Method