sheet_properties: Get data about (work)sheets

Description Usage Arguments Value See Also Examples

View source: R/sheet_properties.R

Description

Reveals full metadata or just the names for the (work)sheets inside a (spread)Sheet.

Usage

1
2
3

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().

Value

See Also

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

Examples

1
2
3
4
5
if (gs4_has_token()) {
  ss <- gs4_example("gapminder")
  sheet_properties(ss)
  sheet_names(ss)
}

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