Get Named Ranges from Excel File

getNamedExcelRanges(
  file,
  pattern = "^range",
  dbg = TRUE,
  stringsAsFactors = FALSE,
  ...
)

Arguments

file	path to Excel file
pattern	pattern matching the names of named cell ranges to be read. By default, all ranges starting with `range` are read.
dbg	logical. If `TRUE` debug messages are shown
stringsAsFactors	passed to `hsGetTable`
...	further arguments passed to `hsGetTable`

list of data frames each of which represents the content a named cell range in the Excel file and each of which was read with hsGetTable.