groupColumns {openxlsx}

Group columns

Description

Group a selection of columns

Usage

groupColumns(wb, sheet, cols, hidden = FALSE)

Arguments

wb

A workbook object.

sheet

A name or index of a worksheet.

cols

Indices of cols to group.

hidden

Logical vector. If TRUE the grouped columns are hidden. Defaults to FALSE.

Details

Group columns together, with the option to hide them.

NOTE: setColWidths() has a conflicting hidden parameter; changing one will update the other.

Author(s)

Joshua Sturm

See Also

ungroupColumns() to ungroup columns. groupRows() for grouping rows.