writexl1.4.1 bug: Empty field -> "nan(snan) about writexl HOT 5 CLOSED

Writexl 1.4.2 is on cran now.

from writexl.

Can you link to your test_file.xlsx so that I can test the problem?

from writexl.

Can you link to your test_file.xlsx so that I can test the problem?

We have seen the same issue when using writexl 1.4.1. The following example would show the same error without importing any file:

library(writexl)

# create data with timestamp
check <- data.frame(
  TestCol= rep("GV", 3),
  Time = c(Sys.time(), NA, NA)
)

# write data
write_xlsx(
  check,
  "check.xlsx"
)

from writexl.

I think we already fixed this a while ago but it's not on CRAN yet. Can you try with writexl 1.4.2? You can install it from :

install.packages("writexl", repos = "https://ropensci.r-universe.dev")

from writexl.

I think we already fixed this a while ago but it's not on CRAN yet. Can you try with writexl 1.4.2? You can install it from :

install.packages("writexl", repos = "https://ropensci.r-universe.dev")

Hi jeroen,

Thanks for the reply. Yes, I don't see the issue anymore with writexl 1.4.2. Thanks for your help.

from writexl.