1
I am trying to export a data.frame to Excel, but R shows the following error:
Error in . jnew("org/apache/poi/xssf/usermodel/Xssfworkbook") : Java Exception . jnew("org/apache/poi/xssf/usermodel/Xssfworkbook")new("jobjRef", jobj = , jclass = "java/lang/Outofmemoryerror")
The command that generates the above error is
write.xlsx(base_eng, "base_eng.xlsx")
uses the package
writexl
instead. Packages that have Java dependency often give a lot of trouble.– Tomás Barcellos
writexl::write_xlsx(base_eng, "base_eng.xlsx")
should work after you install the package– Tomás Barcellos