This function is used to add comment to the specified cell
setComments(tableId, cellId, comment)
tableId | the id of the table for which the comment is to be added |
---|---|
cellId | the id of the cell for which the comment is to be added |
comment | the comment that is to be added to the cell |
if(interactive()) { library(shiny) library(excelR) shinyApp( ui = fluidPage(excelOutput("table", height = 175), actionButton('comment', 'Set Comments to cell A1')), server = function(input, output, session) { output$table <- renderExcel(excelTable(data = head(iris))) observeEvent(input$comment,{ setComments("table", "A1", "This is a comment") }) } ) }