groupColumns {openxlsx} | R Documentation |
Group a selection of columns
groupColumns(wb, sheet, cols, hidden = FALSE, level = -1)
wb |
A workbook object. |
sheet |
A name or index of a worksheet. |
cols |
Indices of cols to group. Can be either a vector of indices to
group at the same level or a (named) list of numeric vectors of
indices to create multiple groupings at once. The names of the
entries determine the grouping level. If no names are given,
the |
Logical vector. If TRUE the grouped columns are hidden. Defaults to FALSE. | |
level |
Grouping level (higher value indicates multiple nestings) for the group. A vector to assign different grouping levels to the indices. A value of -1 indicates that the grouping level should be derived from the existing grouping (one level added) |
Group columns together, with the option to hide them.
NOTE: setColWidths()
has a conflicting hidden
parameter; changing one will update the other.
Joshua Sturm, Reinhold Kainhofer
ungroupColumns()
to ungroup columns. groupRows()
for grouping rows.