readXL: Read an Excel File

In RcmdrMisc: R Commander Miscellaneous Functions

Read an Excel File

Description

Read an Excel File

Usage

readXL(
  file,
  rownames = FALSE,
  header = TRUE,
  na = "",
  sheet = 1,
  stringsAsFactors = FALSE
)

Arguments

file	name of an Excel file including its path.
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.

Details

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.

Value

a data frame.

Author(s)

John Fox

See Also

read_excel, excel_sheets.

RcmdrMisc documentation built on Jan. 8, 2026, 9:06 a.m.