[R] Error using write.xlsx library(xlsx)

Quark at gmx.at Quark at gmx.at
Fri Jan 28 13:46:48 CET 2011

Dear Adrian,

I would like to export a quite large matrix from R to Excel (40 columns, 257 597 rows). After 10 minutes of work, I get the following error message:

Error in .jcall(row[[ir]], "Lorg/apache/poi/ss/usermodel/Cell;", "createCell",  : 
Java Exception <no description because toString() failed>

This is the code I used:

write.xlsx(wvs19812008hm, "C:/test.xlsx", sheetName="Sheet 1", formatTemplate=NULL, col.names=TRUE, row.names=TRUE, append=FALSE)

Is the matrix simply too large? (NB: I use the 64bit version of Windows 7 and R x64 2.12.1)


GMX DSL Doppel-Flat ab 19,99 Euro/mtl.! Jetzt mit 
gratis Handy-Flat! http://portal.gmx.net/de/go/dsl

More information about the R-help mailing list