Repository navigation
excel_to_R function does not work #118
Description
Activity
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?
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
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):