Sheet: Functions to manipulate worksheets.

Description Usage Arguments Value Author(s) See Also Examples

Description

Functions to manipulate worksheets.

Usage

1
2
3
4
5
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.

Author(s)

Adrian Dragulescu

See Also

To extract rows from a given sheet, see Row.

Examples

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
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()

colearendt/xlsx documentation built on Oct. 11, 2018, 12:23 a.m.