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.mckown@gmail.com>
wrote:

> On Thu, Jul 24, 2014 at 8:36 PM, Keith S Weintraub <kw1958@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]]

