set_table_formula method

set_table_formula

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

def set_table_formula(self, row_number, column_number, row_input_cell, column_input_cell, values):
    ...

Parameter	Type	Description
row_number	int	Number of rows to populate the formula.
column_number	int	Number of columns to populate the formula.
row_input_cell	str	the row input cell
column_input_cell	str	the column input cell
values	list	values for cells in table formula range

set_table_formula

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

def set_table_formula(self, row_number, column_number, input_cell, is_row_input, values):
    ...

Parameter	Type	Description
row_number	int	Number of rows to populate the formula.
column_number	int	Number of columns to populate the formula.
input_cell	str	the input cell
is_row_input	bool	Indicates whether the input cell is a row input cell(true) or a column input cell(false).
values	list	values for cells in table formula range

set_table_formula

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

def set_table_formula(self, row_number, column_number, row_index_of_input_cell, column_index_of_input_cell, is_row_input, values):
    ...

Parameter	Type	Description
row_number	int	Number of rows to populate the formula.
column_number	int	Number of columns to populate the formula.
row_index_of_input_cell	int	row index of the input cell
column_index_of_input_cell	int	column index of the input cell
is_row_input	bool	Indicates whether the input cell is a row input cell(true) or a column input cell(false).
values	list	values for cells in table formula range

set_table_formula

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

def set_table_formula(self, row_number, column_number, row_index_of_row_input_cell, column_index_of_row_input_cell, row_index_of_column_input_cell, column_index_of_column_input_cell, values):
    ...

Parameter	Type	Description
row_number	int	Number of rows to populate the formula.
column_number	int	Number of columns to populate the formula.
row_index_of_row_input_cell	int	row index of the row input cell
column_index_of_row_input_cell	int	column index of the row input cell
row_index_of_column_input_cell	int	row index of the column input cell
column_index_of_column_input_cell	int	column index of the column input cell
values	list	values for cells in table formula range

See Also

• module aspose.cells
• class Cell