How to create datatable with complex header in R Shiny?

Question

I have a datatable in R Shiny and would like to have headers that span multiple columns like below:

enter image description here

How can this be achieved in R Shiny?

score 14 · Accepted Answer · answered Aug 29 '17 at 08:44

14

Theres already example http://rstudio.github.io/DT/

library(DT)
sketch = htmltools::withTags(table(
  class = 'display',
  thead(
    tr(
      th(rowspan = 2, 'Species'),
      th(colspan = 2, 'Sepal'),
      th(colspan = 2, 'Petal')
    ),
    tr(
      lapply(rep(c('Length', 'Width'), 2), th)
    )
  )
))
datatable(iris[1:20, c(5, 1:4)], container = sketch, rownames = FALSE)

answered Aug 29 '17 at 08:44

Pork Chop

26,081
5
59
70

Is it possible to write this table into excel? – Cafer Cruz Jun 26 '20 at 11:34
If u want to know how to export is https://rstudio.github.io/DT/extensions.html. Have a look at the `2 Buttons` – Pork Chop Jun 26 '20 at 12:26

score 2 · Answer 2 · answered May 19 '15 at 10:19

2

Have a look at new package from RStudio DT (https://github.com/rstudio/DT)? Here http://rstudio.github.io/DT/ you could find an example of what you need.

answered May 19 '15 at 10:19

kismsu

1,009
7
20

How to create datatable with complex header in R Shiny?

2 Answers2

Linked