Read a contiguous set of rows into an R character matrix. Uses the
RInterface for speed.
readRows(sheet, startRow, endRow, startColumn, endColumn = NULL)a Worksheet object.
a numeric value for the starting row.
a numeric value for the ending row. If NULL it reads
all the rows in the sheet.
a numeric value for the starting column.
a numeric value for the ending column. Empty cells will be returned as "".
A character matrix.
Use the readRows function when you want to read a row or a block
block of data from an Excel worksheet. Internally, the loop over rows is
done in R, and the loop over columns is done in Java, so this function
achieves good performance when number of rows << number of columns.
In general, you should prefer the function readColumns over
this one.
read.xlsx2 for reading entire sheets. See also
addDataFrame for writing a data.frame to a sheet.
if (FALSE) {
file <- system.file("tests", "test_import.xlsx", package = "xlsx")
wb <- loadWorkbook(file)
sheets <- getSheets(wb)
sheet <- sheets[["all"]]
res <- readRows(sheet, startRow=3, endRow=7, startColumn=3, endColumn=10)
}