getComments: This function is used to get comment from specified cell

Description Usage Arguments Examples

View source: R/comments.R

Description

This function is used to get comment from specified cell

Usage

1
getComments(tableId, cellId)

Arguments

tableId

the id of the table from which the comment is to be fetched

cellId

the id of the cell from which the comment is to be fetched

Examples

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
if(interactive()) {
 library(shiny)
 library(excelR)
 shinyApp(
     ui = fluidPage(excelOutput("table", height = 175),
          actionButton('comment', 'Get Comments from cell A1')),
     server = function(input, output, session) {
         output$table <- renderExcel(excelTable(data = head(iris)))
         observeEvent(input$comment, {
             getComments("table", "A1")
         })
         observeEvent(input$table, {
         print(input$table$comment)
         })
     }
     )
 }

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