excelR (version 0.4.0)

get_selected_data_boundary: Get selected cells boundary from excel table

Description

This function is used to the boundary points of data selected in excel table

Usage

get_selected_data_boundary(excelObj)

Arguments

excelObj

the json data retuned from excel table

Examples

# NOT RUN {
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_boundary(input$table))
     })
   }
 )
}
# }