cloneWorksheet {openxlsx} | R Documentation |
Clone a worksheet to a workbook
Description
Clone a worksheet to a Workbook object
Usage
cloneWorksheet(wb, sheetName, clonedSheet)
Arguments
wb |
A Workbook object to attach the new worksheet |
sheetName |
A name for the new worksheet |
clonedSheet |
The name of the existing worksheet to be cloned. |
Value
XML tree
Author(s)
Reinhold Kainhofer
Examples
## Create a new workbook
wb <- createWorkbook("Fred")
## Add 3 worksheets
addWorksheet(wb, "Sheet 1")
cloneWorksheet(wb, "Sheet 2", clonedSheet = "Sheet 1")
## Save workbook
## Not run:
saveWorkbook(wb, "cloneWorksheetExample.xlsx", overwrite = TRUE)
## End(Not run)
[Package openxlsx version 4.2.6.1 Index]