Reads a spreadsheet from excel and converts it to a list for use of bgvar
.
excel_to_list(file, first_column_as_time=TRUE, skipsheet=NULL, ...)
A path to the file.
Logical indicating whether the first column indicates the time.
If one or more sheets should be skipped for reading, this can be provided with this argument. Either a vector of numeric indices or a vector of strings.
Additional arguments.
Returns a list of length N
which contains each a matrix of size T times k, where T are time periods and k variables per entity.
Note that each sheet has to be named for a respective country. Column names are used as variable names. Reader uses the readxl
R package, hence additional arguments can be passed to the function. Furthermore, if first_column_as_time=TRUE
then the column name has also to be time.
bgvar
for estimation of a bgvar
object.