Manipulate table for Excel style

[tanthiamhuat]

I remember there is one excellent R package which is able to manipulate a table to show it like in Excel style like that attached picture. But I forget about which one.

Can anyone recommend such a R package for such purpose?

Thanks.

[ojessen]

I've been working a lot with formattable package, which works nicely together with the officeR package, if you want to produce output in Word or Powerpoint. the https://cran.r-project.org/web/packages/formattable/vignettes/formattable-data-frame.html

[tanthiamhuat]

thanks for the suggestion.. however, my needs is to manipulate the data into the above format like Excel as attached photo... which package is suitable? formattable which you suggested does not seem able to do it.

[tanthiamhuat]

Create Awesome HTML Table with knitr::kable and kableExtra

above is the one which can group ... I remember there is another package which can do it too.

[tanthiamhuat]

https://ardata-fr.github.io/flextable-book/ this is good too