ExcelFile.GetWhatIfTable Method
Returns the range of cells that make the what-if table that starts at aRow and aCol. If there is no What-if table at aRow, aCol, this method returns null.
If both the returned rowInputCell and colInputCell are null, this means this table points to deleted references.
Syntax
Namespace: FlexCel.Core
public abstract TXlsCellRange GetWhatIfTable(Int32 sheet, Int32 row, Int32 col, out TCellAddress rowInputCell, out TCellAddress colInputCell)
Parameters
<-> | Parameter | Type | Description |
---|---|---|---|
sheet | Int32 | Sheet where the table is. | |
row | Int32 | First cell from where we want to get a what-if table. | |
col | Int32 | First cell from where we want to get a what-if table. | |
out | rowInputCell | TCellAddress | Returns the row input cell for this table. If the table doesn't have a row input cell, this value is null. |
out | colInputCell | TCellAddress | Returns the column input cell for this table. If the table doesn't have a column input cell, this value is null. |
Returns
The full range of the table, not including the formula headers. Only the cells where {=Table()} formulas are..