Learn R Programming

googlesheets4 (version 0.1.0)

sheets_get: Get Sheet metadata

Description

Retrieve spreadsheet-specific metadata, such as details on the individual (work)sheets or named ranges.

  • sheets_get() complements googledrive::drive_get(), which returns metadata that exists for any file on Drive.

  • sheets_sheets() is a very focused function that only returns (work)sheet names.

Usage

sheets_get(ss)

sheets_sheets(ss)

Arguments

ss

Something that identifies a Google Sheet: its file ID, a URL from which we can recover the ID, or a dribble, which is how googledrive represents Drive files. Processed through as_sheets_id().

Value

  • sheets_get(): A list with S3 class sheets_meta, for printing purposes.

  • sheets_sheets(): A character vector.

Examples

Run this code
# NOT RUN {
if (sheets_has_token()) {
  sheets_get(sheets_example("mini-gap"))
}
if (sheets_has_token()) {
  sheets_sheets(sheets_example("deaths"))
}
# }

Run the code above in your browser using DataLab