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.