Sheet {xlsx}

Functions to manipulate worksheets.

Description

Functions to manipulate worksheets.

Usage

getSheets(wb)

createSheet(wb, sheetName = "Sheet1")

removeSheet(wb, sheetName = "Sheet1")

Arguments

wb

a workbook object as returned by createWorksheet or loadWorksheet.

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.

Author(s)

Adrian Dragulescu

See Also

To extract rows from a given sheet, see Row.

Examples

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()