Read from an Excel file or Workbook object
Read data from an Excel file or Workbook object into a data.frame
readWorkbook( xlsxFile, sheet = 1, startRow = 1, colNames = TRUE, rowNames = FALSE, detectDates = FALSE, skipEmptyRows = TRUE, skipEmptyCols = TRUE, rows = NULL, cols = NULL, check.names = FALSE, sep.names = ".", namedRegion = NULL, na.strings = "NA", fillMergedCells = FALSE )
xlsxFile |
An xlsx file, Workbook object or URL to xlsx file. |
sheet |
The name or index of the sheet to read data from. |
startRow |
first row to begin looking for data. Empty rows at the top of a file are always skipped, regardless of the value of startRow. |
colNames |
If |
rowNames |
If |
detectDates |
If |
skipEmptyRows |
If |
skipEmptyCols |
If |
rows |
A numeric vector specifying which rows in the Excel file to read. If NULL, all rows are read. |
cols |
A numeric vector specifying which columns in the Excel file to read. If NULL, all columns are read. |
check.names |
logical. If TRUE then the names of the variables in the data frame are checked to ensure that they are syntactically valid variable names |
sep.names |
One character which substitutes blanks in column names. By default, "." |
namedRegion |
A named region in the Workbook. If not NULL startRow, rows and cols parameters are ignored. |
na.strings |
A character vector of strings which are to be interpreted as NA. Blank cells will be returned as NA. |
fillMergedCells |
If TRUE, the value in a merged cell is given to all cells within the merge. |
Creates a data.frame of all data in worksheet.
data.frame
Alexander Walker
xlsxFile <- system.file("extdata", "readTest.xlsx", package = "openxlsx")
df1 <- readWorkbook(xlsxFile = xlsxFile, sheet = 1)
xlsxFile <- system.file("extdata", "readTest.xlsx", package = "openxlsx")
df1 <- readWorkbook(xlsxFile = xlsxFile, sheet = 1, rows = c(1, 3, 5), cols = 1:3)Please choose more modern alternatives, such as Google Chrome or Mozilla Firefox.