WIP. Name should maybe involve "meta" or "metadata"? OTOH there's an obvious connection to googledrive::drive_get().

sheets_get(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

A list with S3 class sheets_meta, for printing purposes.

Examples

sheets_get(sheets_example("design-dates"))
#> Spreadsheet name: googlesheets4-design-exploration #> ID: 1xTUxWGcFLtDIHoYJ1WsjQuLmpUtBf--8Bcu5lQ302SU #> Locale: en_US #> Time zone: America/Los_Angeles #> # of sheets: 10 #> #> (Sheet name): (Nominal extent in rows x columns) #> Sheet1: 1001 x 26 #> date_format_quoting_problem: 1000 x 26 #> hidden_sheet: 1000 x 26 #> named_ranges: 1000 x 26 #> ff: 1000 x 26 #> cell-specification: 999 x 26 #> this:that: 1000 x 26 #> A2: 1000 x 26 #> Jenny's S[h!e:e't: 1000 x 26 #> types: 1000 x 26
sheets_get(sheets_example("gapminder"))
#> Spreadsheet name: test-gs-gapminder #> ID: 1BzfL0kZUz1TsI5zxJF1WNF01IxvC67FbOJUiiGMZ_mQ #> Locale: en_US #> Time zone: Etc/GMT #> # of sheets: 5 #> #> (Sheet name): (Nominal extent in rows x columns) #> Africa: 625 x 6 #> Americas: 301 x 6 #> Asia: 397 x 6 #> Europe: 361 x 6 #> Oceania: 25 x 6
sheets_get(sheets_example("mini-gap"))
#> Spreadsheet name: test-gs-mini-gapminder #> ID: 1BMtx1V2pk2KG2HGANvvBOaZM4Jx1DUdRrFdEx-OJIGY #> Locale: en_US #> Time zone: Etc/GMT #> # 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
sheets_get(sheets_example("ff"))
#> Spreadsheet name: gs-test-formula-formatting #> ID: 132Ij_8ggTKVLnLqCOM3ima6mV9F8rmY7HEcR-5hjWoQ #> Locale: en_US #> Time zone: America/Los_Angeles #> # of sheets: 1 #> #> (Sheet name): (Nominal extent in rows x columns) #> Sheet1: 1000 x 25