Sheet
From xlsx v0.6.5
by Cole Arendt
Functions to manipulate worksheets.
Functions to manipulate worksheets.
Usage
getSheets(wb)createSheet(wb, sheetName = "Sheet1")
removeSheet(wb, sheetName = "Sheet1")
Arguments
- wb
a workbook object as returned by
createWorksheet
orloadWorksheet
.- sheetName
a character specifying the name of the worksheet to create, or remove.
Value
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.
See Also
To extract rows from a given sheet, see Row
.
Examples
# NOT RUN {
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
rJava::.jmethods(sheet)
# for example
sheet$getLastRowNum()
# }
Community examples
Looks like there are no examples yet.