How to hide empty columns of datatables in R shiny?

Question

My datatables contain empty columns. How I can easily hide/remove them in R Shiny?

## Data table output format
data_output <- function(data, targets_number) {
    DT::datatable(data, rownames= FALSE, filter = 'top', extensions = c('Buttons','FixedHeader', 'KeyTable'), options = list(columnDefs = list(list(
      targets = targets_number,
      render = JS(
        "function(data, type, row, meta) {",
        "return type === 'display' && data.length > 60 ?",
        "'<span title=\"' + data + '\">' + data.substr(0, 60) + '...</span>' : data;",
        "}")
    )), orderClasses = TRUE, scrollX = TRUE, scrollY= TRUE, lengthMenu = list(c(4, 25, 100, -1), c('4', '25', '100', 'All')), pageLength = 4, dom = 'lr<"sep">CBtip', buttons = c(I('colvis'), 'copy', 'excel'), fixedHeader = TRUE, keys = TRUE, autoWidth = TRUE, deferRender = TRUE), callback = JS('table.page(1).draw(false);'))
  }

output$drugTable <- renderDT ({data_output(drug_sql_data,13)})

Jos · Accepted Answer · 2022-12-15 08:15:48Z

-1

I don't know what R Shiny is, but I've managed to hide all empty columns with this: https://stackoverflow.com/a/74808566/757201

answered Dec 15, 2022 at 8:15

Jos

1,4841 gold badge15 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to hide empty columns of datatables in R shiny?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related