Reads an excel sheet with labelled data

Assumes variable labels are on row 1 and variable names are on row 2.

Usage

read_labelled_sheet(path, sheet, date_detect = NULL, start_row = 1L)

Arguments

path

to the xls/xlsx file, including data set name and extension

sheet

name of sheet to import

date_detect

regex expression indicating variables to be imported as dates

start_row

integer row position where labels are placed, defaults to 1L

Value

a tibble

Examples

if (FALSE) { # \dontrun{
d1 <- read_labelled_sheet(
  path = here::here(path, dsn1),
  sheet = "ae_listings",
  date_detect = "cyc1_visdat|cyc2_visdat"
)
} # }