excel_to_R {excelR}

Convert excel object to data.frame

Description

This function is used to excel data to data.frame. Can be used in shiny app to convert input json to data.frame

Usage

excel_to_R(excelObj)

Arguments

excelObj

the json data retuned from excel table

Examples

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))
     })
   }
 )
}