Cell.SetTableFormula
Contents
[
Hide
]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
- class Cell
- namespace Aspose.Cells
- assembly Aspose.Cells
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
- class Cell
- namespace Aspose.Cells
- assembly Aspose.Cells
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
- class Cell
- namespace Aspose.Cells
- assembly Aspose.Cells
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
- class Cell
- namespace Aspose.Cells
- assembly Aspose.Cells