Can't export a data frame to xlsx file

Asked May 29 '18 at 07:41

Active May 29 '18 at 07:41

Viewed 526 times

I need to export a data frame to xlsx file

DATA_BASE<-as.data.frame(DATA_BASE)

# EXPORT THE DATATABLE TO CSV FILE IN EXCEL

library(xlsx)
write.xlsx(as.data.frame(DATA_BASE),"C:/Users/isalah/Desktop/Fichiers_CRM/NEW_NEW_NEW/DATA_VISUALIZATION.xlsx",sheetName="Sheet1")

, But I get this error :

Error in .jnew("org/apache/poi/xssf/usermodel/XSSFWorkbook") :
java.lang.OutOfMemoryError: Java heap space

I searched and I get a response here :

Error in printing data.frame in excel using XLSX package in R

But I already convert the DATA_BASE as data frame!

How do I resolve this, please?

asked May 29 '18 at 07:41

Rprogrammer

try using package `openxlsx` – phiver May 29 '18 at 07:44
@phiver, thank you for your response, But I get an error in installing this package! `Error in library(openxlsx) :no package named 'openxlsx' is found` – Rprogrammer May 29 '18 at 07:51
1

try installing it first. `install.packages("openxlsx")` – phiver May 29 '18 at 07:55
@phiver, yes I did this and also I changed each timethe CRAN and I also tried this `install.packages("openxlsx",dependicies=TRUE)`. – Rprogrammer May 29 '18 at 07:57
If you are trying to create a CSV anyway, `write.csv` or `write.table( .. , sep = ",")` would be an option. – r.user.05apr May 29 '18 at 08:03
@r.user.05apr look what I get `unused argument (sep = ",")` – Rprogrammer May 29 '18 at 08:05
1

`write.table(DATA_BASE, file = "c: ..\\xx.csv", sep = ","); write.csv(DATA_BASE, file = "c: ..\\xx.csv")`. If you are using write.csv, you don't need sep. Hope that's the problem. – r.user.05apr May 29 '18 at 08:13
@r.user.05apr, thank you very much ! it works – Rprogrammer May 29 '18 at 08:22
if you want to stick with the xlsx package you have to increase the memory with a command something like this `options(java.parameters = "-Xmx1000m")` - restart your session, run this command then the `write.xlsx` command – Mike May 29 '18 at 15:09
@Mike, thank you for this information. – Rprogrammer May 30 '18 at 06:55

Can't export a data frame to xlsx file

0 Answers0