Inserts cells into a table.
Syntax
table_name.insertcells(cell_range) insert_arg
where insert_arg specifies what to be inserted or how the surrounding cells should be shifted.
The
cell_range argument defines the cells to be modified. See
Table::setformat for the syntax.
insert_arg may be one of the following:
row | Insert row. |
column | Insert column. |
right | Shift cells in cell_range to the right before inserting new cells. |
down | Shift cells below cell_range down before inserting new cells. |
Examples
tab1.insertcells(2:5) row
inserts four new rows starting at row 2 in the table TAB1.
tab1.insertcells(B2:E5) right
shifts the cells to the right of and including B2 through E5 in table TAB1 by four columns.
tab1.insertcells(B2:E5) down
shifts the cells below and including B2 through E5 in table TAB1 by four rows.
Cross-references
For additional discussion of table commands see
“Working with Tables and Spreadsheets”.