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

get_selected_data

Get selected cells from excel table


Description

This function is used to get the data selected in excel table

Usage

get_selected_data(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), getSelectedData = TRUE))
     observeEvent(input$table,{
       print(get_selected_data(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.