Shiny: Merge cells in DT::datatable

by

It is possible with the help of the datatables-rowsgroup library. Here is an example:

library(shiny)
library(DT)

dat <- iris[c(1,2,3,51,52,53,101,102,103), c(5,1,2,3,4)]

ui <- fluidPage(
  DTOutput("table")
)

server <- function(input, output){
  output[["table"]] <- renderDT({
    dtable <- datatable(dat, rownames = FALSE, 
                        options = list(
                          rowsGroup = list(0) # merge cells of column 1
                        ))
    path <- "U:/Data/shiny/DT/www" # folder containing dataTables.rowsGroup.js
    dep <- htmltools::htmlDependency(
      "RowsGroup", "2.0.0", 
      path, script = "dataTables.rowsGroup.js")
    dtable$dependencies <- c(dtable$dependencies, list(dep))
    dtable
  })
}

shinyApp(ui, server)

enter image description here

More Related Contents:

  1. render dropdown for single column in DT shiny
  2. R Shiny set DataTable column width
  3. DT: Dynamically change column values based on selectinput from another column in R shiny app
  4. Remove ‘search’ option but leave ‘search columns’ option
  5. Edit datatable in Shiny with dropdown selection for factor variables
  6. R Shiny: Handle Action Buttons in Data Table
  7. dynamically add plots to web page using shiny
  8. How to listen for more than one event expression within a Shiny eventReactive handler
  9. How to save plots that are made in a shiny app
  10. R Shiny: reactiveValues vs reactive
  11. drop-down checkbox input in shiny
  12. Shiny: what is the difference between observeEvent and eventReactive?
  13. how to create two independent drill down plot using Highcharter?
  14. How to change ‘Maximum upload size exceeded’ restriction in Shiny and save user file inputs?
  15. Subset based on variable column name
  16. Formatting reactive data.frames in Shiny
  17. Favicon in Shiny
  18. RStudio Shiny ERROR: there is no package called “shinydashboard”
  19. Update handsontable by editing table and/or eventReactive
  20. R Shiny Dynamic Input
  21. Shiny: passing input$var to aes() in ggplot2
  22. How to embed an image in a cell a table using DT, R and Shiny
  23. shinydashboard some Font Awesome Icons Not Working
  24. Passing data within Shiny Modules from Module 1 to Module 2
  25. Shiny Dashboard – display a dedicated “loading..” page until initial loading of the data is done
  26. dynamically adjust height and/or width of shiny-plotly output based on window size
  27. R shiny sliderInput with restricted range
  28. Display HTML file in Shiny App
  29. Possible to show console messages (written with `message`) in a shiny ui?
  30. Image not showing in Shiny app R

Leave a Comment