Reveals full metadata or just the names for the (work)sheets inside a (spread)Sheet.
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 filesan instance of
googlesheets4_spreadsheet
, which is whatgs4_get()
returns
Processed through
as_sheets_id()
.
Value
sheet_properties()
: A tibble with one row per (work)sheet.sheet_names()
: A character vector of (work)sheet names.
See also
Other worksheet functions:
sheet_add()
,
sheet_append()
,
sheet_copy()
,
sheet_delete()
,
sheet_relocate()
,
sheet_rename()
,
sheet_resize()
,
sheet_write()
Examples
if (gs4_has_token()) {
ss <- gs4_example("gapminder")
sheet_properties(ss)
sheet_names(ss)
}
#> [1] "Africa" "Americas" "Asia" "Europe" "Oceania"