readExcelSheet {reproducer}

readExcelSheet

Description

Function reads data from an Excel file from a specified sheet

Usage

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.

Author(s)

Lech Madeyski

Examples

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