Re: [R] read multiple sheets of excel data into R

2016-05-28 Thread jim holtman
Try the 'openxlsx' package. I gave up using XLConnect because of the Java requirement, and speed on larger tables. "openxlsx" has the access routines written in C so you don't need any other outside dependencies. Jim Holtman Data Munger Guru What is the problem that you are trying to solve?

Re: [R] read multiple sheets of excel data into R

2016-05-28 Thread Jeff Newmiller
Apparently you need to get your Java runtime setup, or install Perl, depending which of these tools you want to use. Or if your data are laid out simply, you might be able to use the readxl package. -- Sent from my phone. Please excuse my brevity. On May 28, 2016 10:55:50 AM PDT, li li

[R] read multiple sheets of excel data into R

2016-05-28 Thread li li
Hi all, I tried to use the package "XLConnect" to read excel data into R. I got the following error message: Error : .onLoad failed in loadNamespace() for 'rJava', details: call: fun(libname, pkgname) error: No CurrentVersion entry in Software/JavaSoft registry! Try re-installing Java and