'Declaration Public Property ColumnInputCell As WorksheetCell
public WorksheetCell ColumnInputCell {get; set;}
| Exception | Description |
|---|---|
| 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 RowInputCell is null. At least one input cell must be non-null. |
| System.InvalidOperationException | The assigned value is the same as RowInputCell. The input cells cannot be the same cell. |
This represents the cell reference in all formulas of the data table to replace with row header values. If this and the RowInputCell 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.
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