0

I am using the Openxlsx package to open an existing Excel file, delete and recreate a tab with new, fresh data. On another sheet in the workbook I have some rows grouped together throughout the sheet using the Group section on the Data tab. When I run my script, everything works perfectly except for some reason the Grouping on the sheet not being used is being removed. Does anyone know a fix for this?

Andrew P
  • 11
  • 2

1 Answers1

0

Maybe try openxlsx::groupColumns(wb, sheet, cols)

JHawkins
  • 243
  • 1
  • 2
  • 10
  • 3
    Avoid answering a question in a way that ask a question... Please rephase it like "This might work for you: " or "Maybe try : ". (The current answer triggered a "not an answer" bot because it looks like a question) – Sabito stands with Ukraine Oct 14 '20 at 03:44