Skip to contents

Create vintages table from XLSX files

Source: R/vintages.R
create_vintages_from_xlsx.Rd

Create vintages table from XLSX files

Usage

create_vintages_from_xlsx(
  file,
  type = c("long", "horizontal", "vertical"),
  periodicity,
  ...
)

Arguments

file

character containing the name of the file which the data are to be read from.

type

character specifying the type of representation of the input between "long", "horizontal" and "vertical" approach.

periodicity

Integer. Periodicity of the time period (12, 4 or 1 for resp. monthly, quarterly or annual data)

...

Arguments to be passed to readxl::read_excel(), for example:

  • sheet character containing the sheet to read

  • range A cell range to read from

  • col_names a boolean to use the first row as column names

  • ...

Value

an object of class rjd3rev_vintages

See also

create_vintages_from_csv(), create_vintages() which this function wraps.

Examples

if (FALSE) { # \dontrun{
file_name <- "myinput.xlsx"
sheet_name <- "Sheet1"
vintages <- create_vintages_from_xlsx(
    file = file_name,
    type = "horizontal",
    periodicity = 12L,
    sheet = sheet_name
)
} # }