Skip to content

Deletes a range of cells and shifts other cells into the deleted area. There are several related tasks that are implemented by other functions:

Usage

range_delete(ss, sheet = NULL, range, shift = NULL)

Arguments

ss

Something that identifies a Google Sheet:

  • its file id as a string or drive_id

  • a URL from which we can recover the id

  • a one-row dribble, which is how googledrive represents Drive files

  • an instance of googlesheets4_spreadsheet, which is what gs4_get() returns

Processed through as_sheets_id().

sheet

Sheet to delete, in the sense of "worksheet" or "tab". You can identify a sheet by name, with a string, or by position, with a number. Ignored if the sheet is specified via range. If neither argument specifies the sheet, defaults to the first visible sheet.

range

Cells to delete. There are a couple differences between range here and how it works in other functions (e.g. range_read()):

  • range must be specified.

  • range must not be a named range.

  • range must not be the name of a (work) sheet. Instead, use sheet_delete() to delete an entire sheet. Row-only and column-only ranges are especially relevant, such as "2:6" or "D". Remember you can also use the helpers in cell-specification, such as cell_cols(4:6), or cell_rows(5).

shift

Must be one of "up" or "left", if specified. Required if range is NOT a rows-only or column-only range (in which case, we can figure it out for you). Determines whether the deleted area is filled by shifting surrounding cells up or to the left.

Value

The input ss, as an instance of sheets_id

Examples

# create a data frame to use as initial data
df <- gs4_fodder(10)

# create Sheet
ss <- gs4_create("range-delete-example", sheets = list(df))
#>  Creating new Sheet: range-delete-example.

# delete some rows
range_delete(ss, range = "2:4")
#>  Editing range-delete-example.
#>  Deleting cells in sheet Sheet1.

# delete a column
range_delete(ss, range = "C")
#>  Editing range-delete-example.
#>  Deleting cells in sheet Sheet1.

# delete a rectangle and specify how to shift remaining cells
range_delete(ss, range = "B3:F4", shift = "left")
#>  Editing range-delete-example.
#>  Deleting cells in sheet Sheet1.

# clean up
gs4_find("range-delete-example") %>%
  googledrive::drive_trash()
#> File trashed:
#>  range-delete-example <id: 12MhssT-OicIfP0TEvp6iQGjcn_Mir4cEXr316LYcTk8>