RcmdrMisc (version 2.5-1)

readXL: Read an Excel File

Description

readXL reads an Excel file, either of type .xls or .xlsx into an R data frame; it provides a front end to the read_excel function in the readxl package. excel_sheets is re-exported from the readxl package and reports the names of spreadsheets in an Excel file.

Usage

readXL(file, rownames = FALSE, header = TRUE, na = "", sheet = 1, 
  stringsAsFactors = default.stringsAsFactors())
  
excel_sheets(path)

Arguments

file, path

path to an Excel file.

rownames

if TRUE (the default is FALSE), the first column in the spreadsheet contains row names (which must be unique---i.e., no duplicates).

header

if TRUE (the default), the first row in the spreadsheet contains column (variable) names.

na

character string denoting missing data; the default is the empty string, "".

sheet

number of the spreadsheet in the file containing the data to be read; the default is 1.

stringsAsFactors

if TRUE then columns containing character data are converted to factors; the default is taken from default.stringsAsFactors().

Value

a data frame

See Also

read_excel, excel_sheets