excel_to_R function does not work

[v0369012]

Describe the bug
I call the function excel_to_R(), it just give me a null value. The example code does also not work.

To Reproduce
if(interactive()){
library(shiny)
library(excelR)
shinyApp(
ui = fluidPage(excelOutput("table")),
server = function(input, output, session) {
output$table <-
renderExcel(excelTable(data = head(iris)))
observeEvent(input$table,{
print(input$table)
print(excel_to_R(input$table))
})
}
)
}

Desktop (please complete the following information):

• OS: Ubuntu 22.04.2 LTS
• Browser chrome
• Version 124.0.6367.119

[JolandadeB]

I seem to be having the same problem but only partially.
Based on some choices from the user, my app will generate an excelOutput.
The user can make some changes in this and then proceed to the next page.
Once the user is on the next page, my app will capture the excelOutput with the changes and save in a dataframe.
Let's say that my users have the choice of "A", "B", "C" and "D" that will alter the initial excelOutput.
With the choices "A", "B" and "C" the app works like expected.
However, when I select "D" the excelOutput input is not captured but is NULL.

Any thoughts on this?

[JolandadeB]

I think I've figured out what was going wrong for me. The excelOutput with option "D" was not changed since the dataframe was like what I wanted. So then there is no input being captured because there was no input. So you cannot have a default value that will be capture by the excel_to_R function