googlesheets (version 0.3.0)

example-sheets: Examples of Google Sheets

Description

These functions return information on some Google Sheets we've published to the web for use in examples and testing. For example, function names that start with gs_gap_ refer to a spreadsheet based on the Gapminder data, which you can visit it in the browser:

Usage

gs_gap_key()
gs_gap_url()
gs_gap_ws_feed()
gs_gap()
gs_mini_gap_key()
gs_mini_gap_url()
gs_mini_gap_ws_feed()
gs_mini_gap()
gs_ff_key()
gs_ff_url()
gs_ff_ws_feed()
gs_ff()

Value

the key, browser URL, worksheets feed or googlesheet object corresponding to one of the example sheets

Functions

• gs_gap_key: Gapminder sheet key

• gs_gap_url: Gapminder sheet URL

• gs_gap_ws_feed: Gapminder sheet worksheets feed

• gs_gap: Gapminder sheet as registered googlesheet

• gs_mini_gap_key: mini Gapminder sheet key

• gs_mini_gap_url: mini Gapminder sheet URL

• gs_mini_gap_ws_feed: mini Gapminder sheet worksheets feed

• gs_mini_gap: mini Gapminder sheet as registered googlesheet

• gs_ff_key: Key to a sheet with numeric formatting and formulas

• gs_ff_url: URL for a sheet with numeric formatting and formulas

• gs_ff_ws_feed: Worksheets feed for a sheet with numeric formatting and formulas

• gs_ff: Registered googlesheet for a sheet with numeric formatting and formulas

Details

• Gapminder sheet

• mini Gapminder sheet

• Sheet with numeric formatting and formulas

Examples

# NOT RUN {
gs_gap_key()
gs_gap_url()
browseURL(gs_gap_url())
gs_gap_ws_feed() # not so interesting to a user!
gs_gap()

gs_ff_key()
gs_ff_url()
gs_ff()
gs_browse(gs_ff())
# }
# NOT RUN {
# }