On Dec 12, 2016, at 6:51 PM, Val <valkremk at gmail.com> wrote:
Hi all,
I have a data frame with more than 100,000 rows.
datx <- function(n,mean,sd) { mean+sd*scale(rnorm(n)) }
dat <- datx(110000,10,2)
1)
WriteXLS(dat, "test4.xls", row.names=FALSE)
Error in WriteXLS(dat, "test4.xls", row.names = FALSE) :
One or more of the data frames named in 'x' exceeds 65,535 rows or 256 columns
I noticed that *.xls has row and column limitations.
How can I take the excess row to the next sheet?
2) I also tried to use xlsx and have a problem
write.xlsx(dat, "test3.xlsx",sheetName="sheet1", row.names=FALSE)
Error in .jnew("org/apache/poi/xssf/usermodel/XSSFWorkbook") :
java.lang.OutOfMemoryError: Java heap
space.jnew("org/apache/poi/xssf/usermodel/XSSFWorkbook")<S4 object of
class "jobjRef">
Any help ?
Thank you in advance