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

gs4_get(ss)

Arguments

ss

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

Value

A list with S3 class googlesheets4_spreadsheet, for printing purposes.

See also

Examples

if (gs4_has_token()) { gs4_get(gs4_example("mini-gap")) }
#> Spreadsheet name: mini-gap #> ID: 1k94ZVVl6sdj0AXfK9MQOuQ4rOhd1PULqpAu2_kr9MAU #> Locale: en_US #> Time zone: America/Los_Angeles #> # of sheets: 5 #> #> (Sheet name): (Nominal extent in rows x columns) #> Africa: 6 x 6 #> Americas: 6 x 6 #> Asia: 6 x 6 #> Europe: 6 x 6 #> Oceania: 6 x 6