Hi, Josh and Ista:
Thanks very much for the replies. I just downloaded and
installed Java x64, and library(xlsx) worked with 64-bit R when it
hadn't before.
This gives me hope I can fix a problem with
writeFindFn2xls{sos}. It works with 32-bit R, and complains that
"odbcConnectExcel is only usable with 32-bit Windows." (Problems with
taking the wrong lesson: I may have erroneously applied that
contraindication for RODBC to Java.)
Thanks again.
Spencer
On 9/4/2013 6:50 PM, Joshua Wiley wrote:
Hi Spencer,
It really is not very hard, and I have never had issue with it:
http://www.oracle.com/technetwork/java/javase/downloads/jdk7-downloads-1880260.html
Just download the x86 and x64 versions for your OS and install. Worst
case, you need to add the directory to the PATH variable in Windows.
I do this regularly so I can use/test either version of R.
Cheers,
Josh
P.S. Emacs + ESS allows for different versions of R and it is not too
difficult to use the 64 or 32 bit version... M-x
R-version-architecture
On Wed, Sep 4, 2013 at 6:36 PM, Spencer Graves
<spencer.gra...@structuremonitoring.com> wrote:
On 9/4/2013 6:09 PM, Ista Zahn wrote:
Hi Spencer,
Why don't you want to install 64bit Java?
That may be a reasonable approach.
I may have Java confused with something else, but I remember hearing
that it was difficult or unwise to try to install both 32- and 64-bit
versions of something like Java or Java Script on the same Windows operating
system. If I need to uninstall 32-bit Java to install 64-bit, who knows
what else I could break. I'm a statistician, not an information
technologist: If I spend more time playing with Java, I'll have less time
for other things I want to do.
Thanks for the reply.
Spencer
On Wed, Sep 4, 2013 at 6:12 PM, Spencer Graves
<spencer.gra...@structuremonitoring.com> wrote:
Hello, All:
What do you recommend for reading a Google Spreadsheet into R? I didn't
find
anything useful using library(sos); findFn('google spreadsheet').
I can solve the problem by downloading the file either as *.ods or *.xlsx
format, then opening it and saving it as *.xls, then using
read.xls{gdata}.
Alternatives I haven't tried use read.xlsx{xlsx} and
readWorksheetFromFile{XLConnect} with 32-bit R. Neither of these work for
me
with 64-bit R, because they can't find an appropriate rJava on my
computer;
see below. (I've been using 64-bit R with Emacs, so switching to 32-bit R
is
not completely trivial.) Similarly, read.gnumeric.sheet{gnumeric}
requires
the "external program, ssconvert", which seems not to be available on my
computer or installed for 64-bit R.
What do you suggest? Avoid 64-bit R unless I really need it? That seems
to
be the message I'm getting from this. (The writeFindFn2xls{sos} also
works
in 32-bit R but fails in 64-bit apparently for the same reason.)
Thanks,
Spencer
library(xlsx)
Loading required package: xlsxjars
Loading required package: rJava
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 make sure R and Java have matching architectures.
Error: package ‘rJava’ could not be loaded
library(XLConnect)
Loading required package: rJava
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 make sure R and Java have matching architectures.
Error: package ‘rJava’ could not be loaded
sessionInfo()
R version 3.0.1 (2013-05-16)
Platform: x86_64-w64-mingw32/x64 (64-bit)
locale:
[1] LC_COLLATE=English_United States.1252
[2] LC_CTYPE=English_United States.1252
[3] LC_MONETARY=English_United States.1252
[4] LC_NUMERIC=C
[5] LC_TIME=English_United States.1252
attached base packages:
[1] stats graphics grDevices utils datasets methods base
______________________________________________
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.
______________________________________________
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.
