Become an expert in R — Interactive courses, Cheat Sheets, certificates and more!
Get Started for Free

excel_to_R

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

excelR

A Wrapper of the 'JavaScript' Library 'jExcel'

v0.4.0
MIT + file LICENSE
Authors
Swechhya Bista [aut, cre], Kent Russell [ctb], Mārcis Bratka [ctb]
Initial release

We don't support your browser anymore

Please choose more modern alternatives, such as Google Chrome or Mozilla Firefox.