Read a Downloaded Spreadsheet
readSpreadsheet(
destfile,
series,
subFileName,
fieldForColumnNames,
deleteFiles
)File path of the downloaded spreadsheet.
Character string giving the name of the data series to retrieve.
Name of the spreadsheet for download according to the source URL.
If replaceColumnNames is TRUE then this variable specifies which columns of the meta data file will be used to construct the column names. Defaults to “Series” but sometimes you may want to change it to “Group” or c(“Group”, “Series”). “SeriesID” is also allowed.
Logical indicating whether to delete the spreadsheet after reading it.
The contents of the spreadsheet. For most series this will be in the form of a list of two data frames, one called “data” and the other “meta”. For some series (see specialCases()), the data is not in the standard format as the rest and so is just returned directly as the results of read_xlsx for each sheet in the spreadsheet.