2003 Files

Description Usage Arguments Value Author(s) See Also Examples

Functions to manipulate worksheets.

getSheets(wb)

createSheet(wb, sheetName = "Sheet1")

removeSheet(wb, sheetName = "Sheet1")

`wb`	a workbook object as returned by `createWorksheet` or `loadWorksheet`.
`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
rJava::.jmethods(sheet)

# for example
sheet$getLastRowNum()