groupColumns

Simplifies the creation of Excel .xlsx files by providing a
high level interface to writing, styling and editing worksheets.
Through the use of 'Rcpp', read/write times are comparable to the
'xlsx' and 'XLConnect' packages with the added benefit of removing the
dependency on Java.

Jan Marvin Garbuszus

openxlsx

Read, Write and Edit xlsx Files

Philipp Schauberger

Alexander Walker

Luca Braglia

Joshua Sturm

Jordan Mark Barbone

David Zimmermann

Reinhold Kainhofer

groupColumns function

<dl><dt>wb</dt>
<dd>A workbook object.</dd>
<dt>sheet</dt>
<dd>A name or index of a worksheet.</dd>
<dt>cols</dt>
<dd>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 <code>level</code> parameter is used as default.</dd>
<dt>hidden</dt>
<dd>Logical vector. If TRUE the grouped columns are hidden. Defaults to FALSE.</dd>
<dt>level</dt>
<dd>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)</dd></dl>

Arguments

Author

Group columns — groupColumns

<dl>

<dt>wb</dt>
<dd>A workbook object.</dd>


<dt>sheet</dt>
<dd>A name or index of a worksheet.</dd>


<dt>cols</dt>
<dd>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 <code>level</code> parameter is used as default.</dd>


<dt>hidden</dt>
<dd>Logical vector. If TRUE the grouped columns are hidden. Defaults to FALSE.</dd>


<dt>level</dt>
<dd>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)</dd>

</dl>

Group columns

groupColumns: Group columns

Description

Usage

Arguments

Author

Details

See Also