Learn R Programming

repmis (version 0.5)

source_XlsxData: Download an Excel data set

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