unmergeCells-methods {XLConnect} | 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 http://www.mirai-solutions.com
workbook
, mergeCells
,
idx2cref
# 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")