SetTableFormula

SetTableFormula(int, int, string, string, object[][])

Create two-variable data table for given range starting from this cell.

public void SetTableFormula(int rowNumber, int columnNumber, string rowInputCell, 
    string columnInputCell, object[][] values)
Parameter Type Description
rowNumber Int32 Number of rows to populate the formula.
columnNumber Int32 Number of columns to populate the formula.
rowInputCell String the row input cell
columnInputCell String the column input cell
values Object[][] values for cells in table formula range

See Also


SetTableFormula(int, int, string, bool, object[][])

Create one-variable data table for given range starting from this cell.

public void SetTableFormula(int rowNumber, int columnNumber, string inputCell, bool isRowInput, 
    object[][] values)
Parameter Type Description
rowNumber Int32 Number of rows to populate the formula.
columnNumber Int32 Number of columns to populate the formula.
inputCell String the input cell
isRowInput Boolean Indicates whether the input cell is a row input cell(true) or a column input cell(false).
values Object[][] values for cells in table formula range

See Also


SetTableFormula(int, int, int, int, int, int, object[][])

Create two-variable data table for given range starting from this cell.

public void SetTableFormula(int rowNumber, int columnNumber, int rowIndexOfRowInputCell, 
    int columnIndexOfRowInputCell, int rowIndexOfColumnInputCell, int columnIndexOfColumnInputCell, 
    object[][] values)
Parameter Type Description
rowNumber Int32 Number of rows to populate the formula.
columnNumber Int32 Number of columns to populate the formula.
rowIndexOfRowInputCell Int32 row index of the row input cell
columnIndexOfRowInputCell Int32 column index of the row input cell
rowIndexOfColumnInputCell Int32 row index of the column input cell
columnIndexOfColumnInputCell Int32 column index of the column input cell
values Object[][] values for cells in table formula range

See Also


SetTableFormula(int, int, int, int, bool, object[][])

Create one-variable data table for given range starting from this cell.

public void SetTableFormula(int rowNumber, int columnNumber, int rowIndexOfInputCell, 
    int columnIndexOfInputCell, bool isRowInput, object[][] values)
Parameter Type Description
rowNumber Int32 Number of rows to populate the formula.
columnNumber Int32 Number of columns to populate the formula.
rowIndexOfInputCell Int32 row index of the input cell
columnIndexOfInputCell Int32 column index of the input cell
isRowInput Boolean Indicates whether the input cell is a row input cell(true) or a column input cell(false).
values Object[][] values for cells in table formula range

See Also