Is there a way to delete ROWS in a worksheet

[andyosborn]

I can use deleteData to clear a section of cells but what I want to do is the equivalent (in Excel) of selecting a group of rows in the middle of a sheet, right click and selecting "Delete". I have tried various workarounds, like using deleteData, saving the workbook and reopening with readWorkbook(outputfile, sheet = "Sightings", skipEmptyRows = TRUE ...) but this results in the data and formatting getting mixed up. Apologies if I am being particularly dumb here, surely there is a way to do this?

[Paykoman]

If this feature gets implemented, it would also be nice to be able to delete whole COLUMNS.

[kerry-ja]

I agree this would be a useful feature. What I would ideally like to see is something similar to deleteData, but instead of gridExpand an option to specify the type of delete with the 4 options that are in Excel (Shift cells left, Shift cells up, Entire row, Entire column).

[jzadra]

+1

[DavZim]

+1

[benyamindsmith]

+1

[lewkrr]

+1