在闪亮的应用程序编辑数据表后下载按钮消失(download button disappear aft

2019-10-28 16:10发布

我已经包含在我的闪亮的应用程序我在组织开发的可编辑的表格。 使用这个简单的例子来说明这个问题。 这是这个的延伸问题

在这个程序后,我编辑的任何单元格,下载按钮即可消失。 有谁知道为什么出现这种情况? 非常感谢提前。

library(shiny)
library(DT)
library(dplyr)

# UI
ui = fluidPage(
    selectInput("nrows",
                "select n entries",
                choices = 100:150,
                selected = 100,
                multiple = FALSE),
    downloadButton("download1", "Download iris as csv"),
    DTOutput('tbl'),
    checkboxGroupInput(
        'datacols', 
        label='Select Columns:',
        choices= c('Sepal.Length', 'Sepal.Width', 'Petal.Length', 'Petal.Width', 'Species'),
        selected = c('Sepal.Length', 'Sepal.Width', 'Petal.Length', 'Petal.Width', 'Species'),
        inline=TRUE)

)

# SERVER
server = function(input, output) {

    dat = reactiveValues()
    observe ({

        dat$dat = iris[1:input$nrows, ]

    })
    # render DT
    output$tbl = renderDT({
        datatable(dat$dat,
                  editable = "cell",
                  callback = JS(
                      "$('div.dwnld').append($('#download1'));",
                      "var checkboxes = $('input[name=datacols]');",
                      "checkboxes.each(function(index,value){",
                      "  var column = table.column(index+1);",
                      "  $(this).on('click', function(){",
                      "    if($(this).prop('checked')){",
                      "      column.visible(true);",
                      "    }else{",
                      "      column.visible(false);",
                      "    }",
                      "  });",
                      "});"
                  ),
                  extensions = "Buttons",
                  options = list(
                      dom = 'B<"dwnld">frtip',
                      buttons = list("copy")
                  ) 
        )

    })

    observeEvent(input[["tbl_cell_edit"]], {
        cellinfo <- input[["tbl_cell_edit"]]
        dat$dat <<- editData(dat$dat, cellinfo, "tbl")
    })

    output$download1 <- downloadHandler(
        filename = function() {
            paste("data_", Sys.Date(), ".csv", sep="")
        },
        content = function(file) {
            write.csv(dat$dat %>% select(one_of(input$datacols)), file)
        }
    )

}

shinyApp(ui, server)
文章来源: download button disappear after editing data table in shiny app
标签: r shiny dt shinyjs