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_ida 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 (FALSE) { # gs4_has_token()
ss <- gs4_example("gapminder")
sheet_properties(ss)
sheet_names(ss)
}
