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..
See also