source_XlsxData function

Download an Excel data set

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

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.

Returns

a data frame

See Also

read.xlsx, httr , source_data