Get Named Ranges from Excel File — getNamedExcelRanges • kwb.db

Get Named Ranges from Excel File

Usage

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

Value

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