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