I am trying to read an xlsx spreadsheet (1506 rows, 501columns) all populated but getting the following error: Please advise as to how to get around this issue.
> res <- read.xlsx("c:\\BSE_v2.xlsx",1) Error in .jcall("RJavaTools", "Ljava/lang/Object;", "invokeMethod", cl, : java.lang.OutOfMemoryError: Java heap space Here is the session info: > sessionInfo() R version 2.12.1 (2010-12-16) Platform: i386-pc-mingw32/i386 (32-bit) locale: [1] LC_COLLATE=English_United States.1252 LC_CTYPE=English_United States.1252 [3] LC_MONETARY=English_United States.1252 LC_NUMERIC=C [5] LC_TIME=English_United States.1252 attached base packages: [1] grid stats graphics grDevices utils datasets methods base other attached packages: [1] xlsx_0.2.4 xlsxjars_0.2.0 rJava_0.8-8 [4] quantmod_0.3-15 TTR_0.20-2 Defaults_1.1-1 [7] urca_1.2-4 RBGL_1.26.0 graph_1.28.0 [10] colorspace_1.0-1 spatstat_1.21-4 deldir_0.0-13 [13] mgcv_1.7-2 reshape_0.8.4 plyr_1.4 [16] fExtremes_2100.77 fTrading_2100.76 fGarch_2110.80 [19] fBasics_2110.79 timeSeries_2130.90 timeDate_2130.91 [22] mc2d_0.1-9 mvtnorm_0.9-96 mixtools_0.4.4 [25] boot_1.2-43 MASS_7.3-9 SuppDists_1.1-8 [28] ghyp_1.5.4 gplots_2.8.0 caTools_1.11 [31] bitops_1.0-4.1 gdata_2.8.1 gtools_2.6.2 [34] numDeriv_2010.11-1 xtable_1.5-6 PerformanceAnalytics_1.0.3.2 [37] sn_0.4-16 mnormt_1.4-0 xts_0.7-5 [40] zoo_1.6-4 RODBC_1.3-2 loaded via a namespace (and not attached): [1] lattice_0.19-13 Matrix_0.999375-46 nlme_3.1-97 tools_2.12.1 [[alternative HTML version deleted]] ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.