This function is used to excel data to data.frame. Can be used in shiny app to convert input json to data.frame
excel_to_R(excelObj)
excelObj | the json data retuned from excel table |
---|
if(interactive()){ library(shiny) library(excelR) shinyApp( ui = fluidPage(excelOutput("table")), server = function(input, output, session) { output$table <- renderExcel(excelTable(data = head(iris))) observeEvent(input$table,{ print(excel_to_R(input$table)) }) } ) }