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)