John, I will look at your solution over the weekend. I looked into openxlsx but I don't think it handles named ranges which are useful.
Thanks for your help, KW On Thursday, July 24, 2014, John McKown <john.archie.mck...@gmail.com> wrote: > On Thu, Jul 24, 2014 at 8:36 PM, Keith S Weintraub <kw1...@gmail.com > <javascript:;>> wrote: > > Folks, > > > > I have been trying to get XLConnect to work on my Linux Mint Maya > machine. > > > > R works fine but this package doesn't seem to want to build. Here is the > message I get after supposedly building XLConnect and rJava: > > > > > >>> require(XLConnect) > >> Loading required package: XLConnect > >> Error : .onLoad failed in loadNamespace() for 'rJava', details: > >> call: dyn.load(file, DLLpath = DLLpath, ...) > >> error: unable to load shared object > '/home/refserv/R/i686-pc-linux-gnu-library/3.1/rJava/libs/rJava.so': > >> libjvm.so: cannot open shared object file: No such file or directory > > > > > > I purged the openJDK and downloaded the 1.7.0_65 JDK form Oracle. > > > > The build and the compile seemed to work ok as there were no errors. For > example I can generate ggplot2 graphs. > > > > I know this is probably the wrong forum but if someone could gently > point me in the right direction I would be very appreciative. > > > > Thanks so much for your time, > > KW > > It works fine for me on Fedora 20 (and 19 before it). When I installed > R, it installed into /usr/lib64/R. There exists a file: > /usr/lib64/R/etc/ldpaths which is executed by the R executable script. > This sets up the LD_LIBRARY_PATH to point to the Java installation on > my machine. In the /usr/lib64/R/bin directory, there is a program > called "javareconf". I would suggest that you run this with the -n > switch, like: > > R CMD /usr/lib64/R/bin/javareconf -n > > This will show you what it _would_ do if you left off the "-n". Make > sure it looks reasonable. If it does, then run the same command, > without the "-n", as the "root" superuser. In my case, that would be: > > sudo R CMD /usr/lib64/R/bin/javareconf > > You need to be "root" because it update the file > /usr/lib64/R/etc/ldpaths . I am fairly sure this will fix your > problem. > > === > > As a possible alternative to XLConnect, have you looked at openxlsx? > It appears to have the same abilities, just some different syntax. It > says that it is written in C and so should be faster than XLConnect. I > have tested both packages, a little, and they both seem to work well. > > Well, it's 22:14 hours here and I wish that I could fall asleep. We're > having problems at work and I know that the "big boss" will blame us > peons if the hardware isn't fixed promptly Despite the fact that we > are only software people and aren't allowed to touch the hardware. Our > management's minds are not using the same logic as mine does. > Frustrating. > > -- > There is nothing more pleasant than traveling and meeting new people! > Genghis Khan > > Maranatha! <>< > John McKown > -- KW [[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.