Sheet {xlsx} | R Documentation |
Functions to manipulate worksheets.
createSheet(wb, sheetName="Sheet1") removeSheet(wb, sheetName="Sheet1") getSheets(wb)
wb |
a workbook object as returned by |
sheetName |
a character specifying the name of the worksheet to create, or remove. |
createSheet
returns the created Sheet
object.
getSheets
returns a list of java object references each
pointing to an worksheet. The list is named with the sheet names.
Adrian Dragulescu
To extract rows from a given sheet, see Row
.
file <- system.file("tests", "test_import.xlsx", package = "xlsx") wb <- loadWorkbook(file) sheets <- getSheets(wb) sheet <- sheets[[2]] # extract the second sheet # see all the available java methods that you can call .jmethods(sheet) # for example sheet$getLastRowNum()