Error while exporting data.frame to Excel

Asked

Viewed 106 times

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")
r

  • uses the package writexl instead. Packages that have Java dependency often give a lot of trouble.

  • writexl::write_xlsx(base_eng, "base_eng.xlsx") should work after you install the package

1 answer

3


You can export to csv using 

write.table(variavel, "C:/arquivo.csv", sep = ",", row.names = FALSE)

Browser other questions tagged r

You are not signed in. Login or sign up in order to post.