write.xlsx error in Error in .jnew and j.check in R

Question

I was trying to write a dataframe with 523370 rows and 3 columns using write.xlsx

write.xlsx(x = dataframe, file = "dataframe.xlsx",
+ sheetName = "dataframe1", row.names = FALSE)

but I get this error :

    Error in .jnew("org/apache/poi/xssf/usermodel/XSSFWorkbook") : 
  Java Exception <no description because toString() failed>.jnew("org/apache/poi/xssf/usermodel/XSSFWorkbook")<S4 object of class "jobjRef">

and I check these question :

• How to clear memory used by rJava? : xlcFreeMemory() and then try to write the file but after a rather long time I get the same error
• R writing excel file with XLSX package taking a long time and error : write.xlsx2() gave me the same error,after running this one : options(java.parameters = "-Xmx1024m")and rebooting the system

But that changed the error changed to:

Error in .jcheck(silent = FALSE) :Java Exception <no description because toString() failed>.jcall(row[[ir]], "Lorg/apache/poi/ss/usermodel/Cell;", "createCell", as.integer(colIndex[ic] - 1))<S4 object of class "jobjRef">

Answer 1

I had the same problem and restarting R did the trick.

If you're using RStudio the keystroke shortcut for restarting R is Ctrl + Shift + F10 (PC) or Command + Shift + F10 (Mac).

Answer 2

Try to use write.xlsx from openxlsx package that does not use java.

openxlsx::write.xlsx(x = dataframe, file = "dataframe.xlsx")