readWorksheetFromFile

0th

Percentile

Reading data from worksheets in an Excel file (wrapper function)

Reads data from worksheets in an Excel file.

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

The path name of the file to read from.

...

Arguments passed to readWorksheet

Details

See readWorksheet for more information.

See Also

readWorksheet, readNamedRegionFromFile, writeWorksheetToFile, writeNamedRegionToFile, onErrorCell

Aliases
  • readWorksheetFromFile
Examples
# NOT RUN {
# multiregion xlsx file from demoFiles subfolder of 
# package XLConnect
demoExcelFile <- system.file("demoFiles/multiregion.xlsx", 
                             package = "XLConnect")

# Read single area from first sheet of existing file,
# "B2:C3" in Excel speak
df.one <- readWorksheetFromFile(demoExcelFile, sheet = 1, 
                                header = FALSE, startCol = 2, 
                                startRow = 2, endCol = 3, 
                                endRow = 3)

# Read three data sets in one from known positions
dflist <- readWorksheetFromFile(demoExcelFile,
                                sheet = c("FirstSheet", 
                                          "FirstSheet", 
                                          "SecondSheet"),
                                header = TRUE, 
                                startRow = c(2,2,3), 
                                startCol = c(2,5,2),
                                endCol = c(5,8,6), 
                                endRow = c(9,15,153))
# }
Documentation reproduced from package XLConnect, version 0.2-15, License: GPL-3

Community examples

Looks like there are no examples yet.