If all else fails, open it in Excel... save as .csv
read.csv()
Nikhil Joshi wrote
>
> 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@ 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.
>
--
View this message in context:
http://r.789695.n4.nabble.com/Problem-with-xlsx-package-tp3298470p4169793.html
Sent from the R help mailing list archive at Nabble.com.
______________________________________________
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.
