Table of Contents

XlsFile.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.XlsAdapter

public override 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..

See also