excel_to_R: Convert excel object to data.frame

Description Usage Arguments Examples

View source: R/excel_to_R.R

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

1
excel_to_R(excelObj)

Arguments

excelObj

the json data retuned from excel table

Examples

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
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))
     })
   }
 )
}

excelR documentation built on March 13, 2020, 1:31 a.m.