Inserting and deleting rows and columns, moving ranges of cellsΒΆ
You can insert rows or columns using the relevant worksheet methods:
The default is one row or column. For example to insert a row at 7 (before the existing row 7):
>>> ws.insert_rows(7)
To delete the columns F:H
:
>>> ws.delete_cols(6, 3)