sheet_relocate: Relocate one or more (work)sheets

Description Usage Arguments Value See Also Examples

View source: R/sheet_relocate.R

Description

Move (work)sheets around within a (spread)Sheet. The outcome is most predictable for these common and simple use cases:

If your relocation task is more complicated and you are puzzled by the result, break it into a sequence of simpler calls to sheet_relocate().

Usage

1
sheet_relocate(ss, sheet, .before = if (is.null(.after)) 1, .after = 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 relocate, in the sense of "worksheet" or "tab". You can identify a sheet by name, with a string, or by position, with a number. You can pass a vector to move multiple sheets at once or even a list, if you need to mix names and positions.

.before, .after

Specification of where to locate the sheets(s) identified by sheet. Exactly one of .before and .after must be specified. Refer to an existing sheet by name (via a string) or by position (via a number).

Value

The input ss, as an instance of sheets_id

See Also

Constructs a batch of UpdateSheetPropertiesRequests (one per sheet):

Other worksheet functions: sheet_add(), sheet_append(), sheet_copy(), sheet_delete(), sheet_properties(), sheet_rename(), sheet_resize(), sheet_write()

Examples

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
if (gs4_has_token()) {
  sheet_names <- c("alfa", "bravo", "charlie", "delta", "echo", "foxtrot")
  ss <- gs4_create("sheet-relocate-demo", sheets = sheet_names)
  sheet_names(ss)

  # move one sheet, forwards then backwards
  ss %>%
    sheet_relocate("echo", .before = "bravo") %>%
    sheet_names()
  ss %>%
    sheet_relocate("echo", .after = "delta") %>%
    sheet_names()

  # reorder and move multiple sheets to the front
  ss %>%
    sheet_relocate(list("foxtrot", 4)) %>%
    sheet_names()

  # put the sheets back in the original order
  ss %>%
    sheet_relocate(sheet_names) %>%
    sheet_names()

  # reorder and move multiple sheets to the back
  ss %>%
    sheet_relocate(c("bravo", "alfa", "echo"), .after = 10) %>%
    sheet_names()

  # clean up
  gs4_find("sheet-relocate-demo") %>%
    googledrive::drive_trash()
}

googlesheets4 documentation built on July 22, 2021, 1:07 a.m.