readExcelSheet function

readExcelSheet

Function reads data from an Excel file from a specified sheet

readExcelSheet(path, sheet, colNames)

Arguments

• path: Path to an Excel file, e.g. /User/lma/datasets/MyDataSet.xls
• sheet: Name of a sheet within an Excel file we want to read
• colNames: If TRUE, first row of data will be used as column names.

Examples

myPath <- system.file("extdata", "DataSet.xlsx", package = "reproducer")
Madeyski15SQJ.NDC <- readExcelSheet(path = myPath, sheet = "Madeyski15SQJ.NDC", colNames = TRUE)

Author(s)

Lech Madeyski