Set default value for NAs about writexl

[jeroen]

This is difficult to do in R when the column type is numeric for example.

What about converting the column to character before writing it to xlsx? Like so:

# Example data
df <- data.frame(x=c(1,2,NA,4))

# Convert x to character
df$x <- as.character(df$x)
df$x[is.na(df$x)] <- "Not available"

# Write to excel
writexl::write_xlsx(df, 'test.xlsx')

[cortinah]

Thank you, yes, indeed, this is what I have been doing, but it would be nice to be able to do it from the call in write_xlsx so user doesn't have to modify the original data frame.

What if you still want to use the numeric attributes of the df? then you have to make a copy just for writing to excel. read_xlsx has the nice parameter (na = "") which allows you to interpret values that are being read as NAs. It would be great if analogous to that write_xlsx also had a (na="") parameter. This allows for cleaner scripting. thanks!