source_XlsxData: Download an Excel data set

In repmis: Miscellaneous Tools for Reproducible Research

Description

source_XlsxData loads Excel data stored at a URL (both http and https) into R.

Usage

source_XlsxData(url, sheet, sha1 = NULL, cache = FALSE,
  clearCache = FALSE, ...)

Arguments

url	character string of the Excel files's URL.
sheet	character string of number of representing the sheet in the workbook to return. Only one sheet at a time can currently be returned
sha1	Character string of the file's SHA-1 hash, generated by source_data. Note if you are using data stored using Git, this is not the file's commit SHA-1 hash.
cache	logical. Whether or not to cache the data so that it is not downloaded every time the function is called.
clearCache	logical. Whether or not to clear the downloaded data from the cache.
...	arguments to pass to read.xlsx from the xlsx package.

Value

a data frame

See Also

read.xlsx, httr, source_data

repmis documentation built on May 2, 2019, 12:48 a.m.