Add comment to a specified cell
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")
})
}
)
}Please choose more modern alternatives, such as Google Chrome or Mozilla Firefox.