I'm using XLConnect with Java on a 64 bit platform. Even after adding
options(java.parameters = "-Xmx4g")
I'm unable to load a 22MB file with extension .xlsx in R.
Some people have suggested openxlsx package but as far as I know, it makes use of rJava as well.