View source: R/readWorksheetFromFile.R
readWorksheetFromFile | R Documentation |
Reads data from worksheets in an Excel file.
readWorksheetFromFile(file, ...)
file |
The path name of the file to read from. |
... |
Arguments passed to readWorksheet |
See readWorksheet for more information.
Thomas Themel
Mirai Solutions GmbH https://mirai-solutions.ch
readWorksheet
,
readNamedRegionFromFile
,
writeWorksheetToFile
,
writeNamedRegionToFile
,
onErrorCell
## 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)) ## End(Not run)
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.