TExcelFile.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
Unit: FlexCel.Core
function TExcelFile.GetWhatIfTable(const sheet: Integer; const row: Integer; const col: Integer; out rowInputCell: TCellAddress; out colInputCell: TCellAddress): TXlsCellRange; virtual; abstract;Parameters
| <-> | Parameter | Type | Description |
|---|---|---|---|
| const | sheet | Integer | Sheet where the table is. |
| const | row | Integer | First cell from where we want to get a what-if table. |
| const | col | Integer | 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..