getNamedExcelRanges: Get Named Ranges from Excel File

View source: R/getNamedExcelRanges.R

getNamedExcelRangesR Documentation

Get Named Ranges from Excel File

Description

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 hsGetTable.


KWB-R/kwb.db documentation built on Oct. 1, 2023, 4:10 a.m.