Row {xlsx} | R Documentation |
Functions to manipulate rows of a worksheet.
createRow(sheet, rowIndex=1:5) getRows(sheet, rowIndex=NULL)
sheet |
a workbook object as returned by createSheet or
subsetting getSheets . |
rowIndex |
a numeric vector specifying the index of rows to
create. For getRows , a NULL value will return all
non empty rows. |
A list of java object references each pointing to a row. The list is named with the row number.
Adrian Dragulescu
To extract the cells from a given row, see Cell
.
file <- system.file("tests", "test_import.xlsx", package = "xlsx") wb <- loadWorkbook(file) sheets <- getSheets(wb) sheet <- sheets[[2]] rows <- getRows(sheet) # get all the rows # see all the available java methods that you can call .jmethods(rows[[1]]) # for example rows[[1]]$getRowNum() # zero based index in Java