Skip to contents

Merge a range of cells

Source: R/xl_merge.R
xl_merge.Rd

`xl_merge()` merges a rectangle of cells into one, as Excel's "Merge and Centre" does. Pass one or a list of them as `xl_sheet(merge = )`.

A merged range holds a single value, so `xl_merge()` carries its own `text` rather than taking it from the data frame. Merging over cells the data frame filled keeps only the merged text, exactly as merging in Excel discards everything but the top-left value.

Usage

xl_merge(range, text = NULL, format = NULL)

Arguments

range

The cells to merge: an Excel range string such as `"A1:C1"`, or a `list(rows = , cols = )` spec. It must cover more than one cell — Excel has no single-cell merge.

text

The text shown in the merged cell. `NULL` leaves it empty.

format

An optional [xl_format] applied to the whole merged range. Merged cells usually want `xl_align(horizontal = "center")`.

Value

An `xl_merge` object.

See also

[xl_sheet], [xl_format]

Other worksheet features: xl_conditional, xl_filter(), xl_filter_keep(), xl_table(), xl_table_column(), xl_validation()

Examples

xl_merge("A1:C1", "Quarterly results",
         format = xl_align(horizontal = "center") + xl_font(bold = TRUE))
#> <xl_merge: A1:C1 "Quarterly results">

df <- data.frame(a = 1:3, b = 4:6)
sheet <- xl_sheet(df, merge = xl_merge("A5:B5", "Total",
                                       format = xl_font(bold = TRUE)))
tmp <- write_xlsx(list(Data = sheet))