readNamedRegionFromFile {XLConnect} | R Documentation |
Reads named regions from an Excel file.
readNamedRegionFromFile(file, ...)
file |
The file name of the workbook to read |
... |
Arguments passed to readNamedRegion |
This is a convenience wrapper to read named regions from a file
without creating an intermediate workbook
object.
See readNamedRegion for more details.
Thomas Themel
Mirai Solutions GmbH http://www.mirai-solutions.com
readNamedRegion
,
readWorksheetFromFile
,
writeNamedRegionToFile
,
writeWorksheetToFile
,
onErrorCell
# 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"))