XLConnect (version 0.2-3)

readNamedRegionFromFile: Reading named regions from an Excel file (wrapper function)

Description

Reads named regions from an Excel file.

Usage

readNamedRegionFromFile(file, name, header = "TRUE")

Arguments

file

The file name of the workbook to read

name

The name of the named region to read from

header

The argument header specifies if the first row should be interpreted as column names. The default value is TRUE.

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

Examples

# 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"))