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