cloneSheet-methods

Cloning/copying worksheets

Clones (copies) a worksheet in a '>workbook.

Usage

# S4 method for workbook,numeric
cloneSheet(object,sheet,name)
# S4 method for workbook,character
cloneSheet(object,sheet,name)

See Also

'>workbook, createSheet, removeSheet, renameSheet, getSheets, existsSheet

Aliases

• cloneSheet
• cloneSheet-methods
• cloneSheet,workbook,character-method
• cloneSheet,workbook,numeric-method

Examples

# NOT RUN {
# mtcars xlsx file from demoFiles subfolder of package XLConnect
demoExcelFile <- system.file("demoFiles/mtcars.xlsx", package = "XLConnect")

# Load workbook
wb <- loadWorkbook(demoExcelFile)

# Clone the 'mtcars' worksheet and assign it the name 'mtcars cloned'
cloneSheet(wb, sheet = "mtcars", name = "mtcars cloned")
# }