writexl icon indicating copy to clipboard operation
writexl copied to clipboard

S3: integer64s become zeros in Excel file

Open EarlGlynn opened this issue 6 years ago • 1 comments

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.

EarlGlynn avatar Oct 16 '18 17:10 EarlGlynn

Did you try the dev version? This was fixed recently.

jeroen avatar Oct 16 '18 17:10 jeroen