Learn R Programming

RcmdrMisc (version 2.9-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 = FALSE)
  
excel_sheets(path)

Value

a data frame

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 (the default is FALSE) then columns containing character data are converted to factors.

Author

John Fox jfox@mcmaster.ca

See Also

read_excel, excel_sheets