Update table from Shiny about excelr HOT 3 CLOSED

Thank you @marciz for reposting the issue. You can download the development version of the package that resolves this issue. I'll close this issue now, if the problem persists in the development version you can reopen the issue again

from excelr.

Thanks @Swechhya , it works now
Ultimately I am trying to create table with calculated variable

library(shiny)
library(excelR)
dt <- iris
dt$mysum <- dt$Sepal.Length + dt$Sepal.Width
shinyApp(
  ui = fluidPage(
    excelOutput("table")
  ),
    server = function(input, output, session) {
    rv <- reactiveValues(
      dt = dt
    )
    output$table <- renderExcel(excelTable(data = rv$dt))
    observeEvent(input$table,{
      dt <- excel_to_R(input$table)
      dt$mysum <- dt$Sepal.Length + dt$Sepal.Width
      rv$dt <- dt
    })
  }
)

It works as expected, just small inconvenience from user perspective is that cells selection is lost when table updates (due to new jexcel)

from excelr.

Yes, @marciz I can see that could be the inconvenience from user perspective. You can raise a new issue for that and I'll try to find a better solution(which could take some time) for table updation than currently implemented, until then this could be a workaround solution.

from excelr.