cloneSheet-methods
From XLConnect v1.0.2
by Martin Studer
Cloning/copying worksheets
Usage
# S4 method for workbook,numeric
cloneSheet(object,sheet,name)
# S4 method for workbook,character
cloneSheet(object,sheet,name)
Arguments
See Also
'>workbook
, createSheet
,
removeSheet
, renameSheet
,
getSheets
, existsSheet
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")
# }
Community examples
pearlveera@gmail.com
at
Jul 2, 2018
XLConnect
v0.2-15
mtcars <- system.file("demofiles/mtcars.xlsx",package = "XLConnect") wb <- loadWorkbook(mtcars) renameSheet(wb, mtcars, mtcars1) cloneSheet(wb,mtcars1,mtcars2)