source_XlsxData: Download an Excel data set

Description Usage Arguments Value See Also

Description

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

Usage

1
2
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



Search within the repmis package
Search all R packages, documentation and source code

Questions? Problems? Suggestions? or email at ian@mutexlabs.com.

Please suggest features or report bugs with the GitHub issue tracker.

All documentation is copyright its authors; we didn't write any of that.