Become an expert in R — Interactive courses, Cheat Sheets, certificates and more!
Get Started for Free

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

Details

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

Manage Google Spreadsheets from R

v0.3.0
MIT + file LICENSE
Authors
Jennifer Bryan [aut, cre], Joanna Zhao [aut]
Initial release

We don't support your browser anymore

Please choose more modern alternatives, such as Google Chrome or Mozilla Firefox.