xlsx (version 0.6.1)

Sheet: Functions to manipulate worksheets.

Description

Functions to manipulate worksheets.

Usage

createSheet(wb, sheetName="Sheet1")
removeSheet(wb, sheetName="Sheet1")
getSheets(wb)

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.

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
#.jmethods(sheet)

# for example
sheet$getLastRowNum()

# }