Skip to content

Feature Request: Add Group and Ungroup columns & rows #32

@jonekeat

Description

@jonekeat

Hi @ycphs

I have a problem to output a data frame to xlsx with certain styling like grouping several columns based on some conditions.

I think it will be great if openxlsx can have functionality to do grouping & ungrouping columns & rows, while user need to do some manipulation on data frame.

Currently I am doing it in a VBscript, and call it from R, which hard to trace bugs.

image
Here is the functionality as discussed, under 'Data' tab in excel

Metadata

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or requestfixedFixed, issue will be closed within 7 dayshelp wantedExtra attention is needed

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions