Using both the dev and latest cran version and editing a calendar type column I receiv

<a class="user-mention notranslate" data-hovercard-type="user" data-hovercard-url="/us

Inconsistent date format on JSON return object about excelr HOT 8 CLOSED

GoodMorgon commented on July 28, 2024

Inconsistent date format on JSON return object

from excelr.

Comments (8)

marciz commented on July 28, 2024

I think the issue is blank in the date field

as.Date("")
Error in charToDate(x) :
character string is not in a standard unambiguous format

from excelr.

GoodMorgon commented on July 28, 2024

That is probably another issue. You can see from the screenshots that the date input indeed is passed along, but with a timestamp addon.

from excelr.

Swechhya commented on July 28, 2024

@GoodMorgon @marciz This issue cannot be replicated even with an empty cell with the example below:

library(shiny)                                                                        
library(excelR)                                                                       

shinyApp(                                                                            
    ui = fluidPage(excelOutput("table")),                                              
    server = function(input, output, session) {                                        
        iris <- iris
        iris$test <- c(rep(as.Date("2019-01-01"),5,),"")
        
        output$table <- renderExcel(excelTable(data = head(iris)))                                        
        observeEvent(input$table,{                                                        
            print(excel_to_R(input$table))                                                  
        })                                                                                
    }                                                                                 
)

Can you please post an example which replicates this issue so that I can merge your PR?

from excelr.

marciz commented on July 28, 2024

@Swechhya , try to delete test row 1. It gets an error

from excelr.

Swechhya commented on July 28, 2024

@marciz Using the latest development version and deleting the first row I am not able to replicate the error. Any pointers why?

from excelr.

marciz commented on July 28, 2024

Press delete button on the first cell of test column. Is there still no error?

from excelr.

Swechhya commented on July 28, 2024