readNamedRegionFromFile

0th

Percentile

Reading named regions from an Excel file (wrapper function)

Reads named regions from an Excel file.

Keywords
IO
Usage
readNamedRegionFromFile(file, ...)
Arguments
file

The file name of the workbook to read

...

Arguments passed to readNamedRegion

Details

This is a convenience wrapper to read named regions from a file without creating an intermediate '>workbook object. See readNamedRegion for more details.

See Also

readNamedRegion, readWorksheetFromFile, writeNamedRegionToFile, writeWorksheetToFile, onErrorCell

Aliases
  • readNamedRegionFromFile
Examples
# NOT RUN {
# multiregion xlsx file from demoFiles subfolder of package XLConnect
demoExcelFile <- system.file("demoFiles/multiregion.xlsx", 
                             package = "XLConnect")
                             
# Load a single named region into a single data.frame.
df <- readNamedRegionFromFile(demoExcelFile, name="Iris")

# Load multiple regions at once - returns a (named) list 
# of data.frames.
df <- readNamedRegionFromFile(demoExcelFile, 
                              name=c("Calendar", "Iris", "IQ"))
# }
Documentation reproduced from package XLConnect, version 0.2-15, License: GPL-3

Community examples

Looks like there are no examples yet.