Error in closing member in the zipfile

[PoisonAlien]

Hello developers,
I received an error while writing a list of large data.frames to an output file.

> library(writexl)
> writexl::write_xlsx(
  x = list(
    Matrix_processed = mat_processed,
    Matrix_signal_intensities =  mu
  ),
  path = "GEO_submission/GA_illumina_submission_matrices.xlsx",
  col_names = TRUE,
  format_headers = TRUE
)
[ERROR][libxlsxwriter/packager.c:1151]: Error in closing member in the zipfile
[ERROR] workbook_close(): Zip ZIP_BADZIPFILE error while creating xlsx file 'GEO_submission/GA_illumina_submission_matrices.xlsx'. This may require the use_zip64 option for large files. System error = Success

Both mat_processed and mu dataframes are of ~2100 mb object.size.

Partially written output xlsx file is of the size 2GB. I am guessing this is the upper size limit for the function?

> devtools::session_info(pkgs = "writexl")
─ Session info ────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────
 setting  value                       
 version  R version 3.6.0 (2019-04-26)
 os       Pop!_OS 18.04 LTS           
 system   x86_64, linux-gnu           
 ui       RStudio                     
 language en_US:en                    
 collate  en_US.UTF-8                 
 ctype    en_US.UTF-8                 
 tz       Europe/Berlin               
 date     2020-03-12                  

─ Packages ────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────
 package * version date       lib source        
 writexl * 1.2     2019-11-27 [1] CRAN (R 3.6.0)

[1] /home/anand/R/x86_64-pc-linux-gnu-library/3.6
[2] /usr/local/lib/R/site-library
[3] /usr/lib/R/site-library
[4] /usr/lib/R/library

[jeroen]

@jmcnamara is there any reason to not enable use_zip64 by default in my bindings (other than Windows XP support)?

[jeroen]

@PoisonAlien I have exposed an option to enable zip64 in write_xlsx

[PoisonAlien]

Thanks, but now I have the following error with the same command.

> writexl::write_xlsx(
+   x = list(
+     Matrix_processed = mat_processed,
+     Matrix_signal_intensities =  mu
+   ),
+   path = "GEO_submission/GA_illumina_submission_matrices.xlsx",
+   col_names = TRUE,
+   format_headers = TRUE
+ )
[ERROR][libxlsxwriter/packager.c:1151]: Error in closing member in the zipfile
[ERROR] workbook_close(): Zip ZIP_BADZIPFILE error while creating xlsx file 'GEO_submission/GA_illumina_submission_matrices.xlsx'. This may require the use_zip64 option for large files. System error = No such file or directory
Error: Error in libxlsxwriter: 'Zip error ZIP_BADZIPFILE (use_zip64 option may be required).'

> devtools::session_info(pkgs = "writexl")
─ Session info ───────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────
 setting  value                       
 version  R version 3.6.0 (2019-04-26)
 os       Pop!_OS 18.04 LTS           
 system   x86_64, linux-gnu           
 ui       RStudio                     
 language en_US:en                    
 collate  en_US.UTF-8                 
 ctype    en_US.UTF-8                 
 tz       Europe/Berlin               
 date     2020-03-15                  

─ Packages ───────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────
 package * version  date       lib source                           
 writexl * 1.2.9000 2020-03-15 [1] Github (ropensci/writexl@8d013ea)

[1] /home/anand/R/x86_64-pc-linux-gnu-library/3.6
[2] /usr/local/lib/R/site-library
[3] /usr/lib/R/site-library
[4] /usr/lib/R/library

[PoisonAlien]

Oops sorry. I forgot to use use_zip64 = TRUE. All good.