Version

RowInputCell Property

Gets or sets the cell used as the row-input cell in the data table.
Syntax
'Declaration
 
Public Property RowInputCell As WorksheetCell
public WorksheetCell RowInputCell {get; set;}

Property Value

The cell used as the row-input cell in the data table.
Exceptions
ExceptionDescription
System.ArgumentException The assigned value does not belong to the same worksheet as the data table.
System.InvalidOperationException The value is assigned after the data table has been removed from the worksheet.
System.InvalidOperationException The value assigned is within the CellsInTable region.
System.InvalidOperationException The assigned value is null and ColumnInputCell is null. At least one input cell must be non-null.
System.InvalidOperationException The assigned value is the same as ColumnInputCell. The input cells cannot be the same cell.
Remarks

This represents the cell reference in all formulas of the data table to replace with column header values. If this and the ColumnInputCell are non-null, the data table is a two-variable data table. Otherwise, if only one is non-null, this is a one-variable data table.

Note: The RowInputCell and ColumnInputCell cannot be within the CellsInTable region.

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

See Also