unmergeCells-methods

0th

Percentile

Unmerging cells

Unmerges cells in a worksheet.

Keywords
methods, utilities
Usage
# S4 method for workbook,character
unmergeCells(object,sheet,reference)
# S4 method for workbook,numeric
unmergeCells(object,sheet,reference)
Arguments
object

The '>workbook to use

sheet

The name or index of the sheet on which to unmerge cells

reference

A cell range specification (character) in the form 'A1:B8'. Note that the specification must exactly correspond to the range of the merged cells.

See Also

'>workbook, mergeCells, idx2cref

Aliases
  • unmergeCells
  • unmergeCells-methods
  • unmergeCells,workbook,character-method
  • unmergeCells,workbook,numeric-method
Examples
# 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")
# }
Documentation reproduced from package XLConnect, version 0.2-15, License: GPL-3

Community examples

Looks like there are no examples yet.