writexl
writexl copied to clipboard
S3: integer64s become zeros in Excel file
Here’s a reproducible example using the bit64 package to create an int64:
library(tidyverse) library(bit64) # as.integer64 library(writexl) library(readxl) d <- tibble(a=pi, b=3L, c=as.integer64(3)) d write_xlsx(d, "saveint64.xlsx") read_xlsx("saveint64.xlsx")
"c" is written to the file as 1.482197E-323 (near zero) instead of the expected 3.
Did you try the dev version? This was fixed recently.