GetCellAssociatedDataTable Method

Gets the data table to which the cell at the specified index belongs.

Syntax

Visual Basic

'Declaration
 
Public Function GetCellAssociatedDataTable( _
   ByVal columnIndex As Integer _
) As WorksheetDataTable

C#

public WorksheetDataTable GetCellAssociatedDataTable( 
   int columnIndex
)

Parameters

columnIndex

The 0-based index of the cell within the WorksheetRow.

Return Value

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

Exceptions

Exception	Description
System.ArgumentOutOfRangeException	columnIndex is less than zero or greater than or equal to the number of columns in the worksheet.
System.InvalidOperationException	If the row was removed from the worksheet.

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 of the cell with GetCellValue(Int32) will return the calculated value for the cell.

Requirements

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