R Graphical Manual

Browse All

Last data update: 2014.03.03

R: Read an Excel File

readXL

R Documentation

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.
`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

Author(s)

John Fox jfox@mcmaster.ca