getNamedExcelRanges: Get Named Ranges from Excel File

In KWB-R/kwb.db: Functions supporting data base access

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 June 11, 2025, 2:55 a.m.