1

After reading (readxl) and writing (writexl) a xlsx file with R, an empty entry changes to "nan(snan)". See attachment: Change from before reading and writing

to after reading and writing

I believe that I hadn't this problem before I updated to writexl 1.4.1. Any ideas?

Code:

require(writexl)

require(readxl)

data<-read_excel("test_file.xlsx")

data$ERF_DATUM[3]<-NA

write_xlsx(data, "test_file.xlsx", col_names = TRUE, format_headers = TRUE)

LKSari_2006
  • 11
  • 3

1 Answers1

0

Issue is resolved in 1.4.2 which is now available in CRAN

Julia Gonzalez
  • 1