Sheet

0th

Percentile

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 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.

Aliases
  • Sheet
  • Worksheet
  • getSheets
  • createSheet
  • removeSheet
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()

# }
Documentation reproduced from package xlsx, version 0.6.3, License: GPL-3

Community examples

Looks like there are no examples yet.