example-sheets: Examples of Google Sheets

In googlesheets: Manage Google Spreadsheets from R

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

Details

• Gapminder sheet

• mini Gapminder sheet

• Sheet with numeric formatting and formulas

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

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

## End(Not run)

googlesheets documentation built on May 2, 2019, 1:57 p.m.