mergeCells-methods | R Documentation |
Merges cells in a worksheet.
## S4 method for signature 'workbook,character' mergeCells(object,sheet,reference) ## S4 method for signature 'workbook,numeric' mergeCells(object,sheet,reference)
object |
The |
sheet |
The name or index of the sheet on which to merge cells |
reference |
A cell range specification ( |
Martin Studer
Mirai Solutions GmbH https://mirai-solutions.ch
workbook
, unmergeCells
,
idx2cref
## Not run: # Load workbook (create if not existing) wb <- loadWorkbook("mergeCells.xlsx", create = TRUE) # Create a worksheet called 'merge' createSheet(wb, name = "merge") # Merge the cells A1:B8 on the worksheet created above mergeCells(wb, sheet = "merge", reference = "A1:B8") # Save workbook saveWorkbook(wb) # clean up file.remove("mergeCells.xlsx") ## End(Not run)
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.