readXL: Read an Excel File

In RcmdrMisc: R Commander Miscellaneous Functions

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)

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.

Value

a data frame

Author(s)

John Fox [e-mail]

See Also

read_excel, excel_sheets

RcmdrMisc documentation built on Sept. 27, 2023, 1:06 a.m.