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

Use this line :

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

It worked for me ...

Answer 2

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

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

Answer 3

I had a similar problem and used write.csv() instead and then saved the csv file as .xlsx from excel. That did the trick.

Answer 4

I get the same error when I use the relative path. You can try to use the absolute paths.

• R version 3.4.4 (2018-03-15)
• Platform: x86_64-pc-linux-gnu (64-bit)
• Running under: Ubuntu 16.04.4 LTS

Answer 5

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 6

You can always use read.csv() and then just save it and a xlsx file if the problem continues.