Download an Excel data set

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