hello
I have been having troubles the last days using r to connect to any databses.
today I am attempting to connect to microsoft excel
the first step I was told to do is install xlconnect, but xlconnectjars will not install. I had errors recently with some packages and was helped by update r to new version even though I use r studio. but I still get this issue today:
R version 3.5.1 (2018-07-02) -- "Feather Spray"
Copyright (C) 2018 The R Foundation for Statistical Computing
Platform: x86_64-apple-darwin15.6.0 (64-bit)
R is free software and comes with ABSOLUTELY NO WARRANTY.
You are welcome to redistribute it under certain conditions.
Type 'license()' or 'licence()' for distribution details.
Natural language support but running in an English locale
R is a collaborative project with many contributors.
Type 'contributors()' for more information and
'citation()' on how to cite R or R packages in publications.
Type 'demo()' for some demos, 'help()' for on-line help, or
'help.start()' for an HTML browser interface to help.
Type 'q()' to quit R.
[Workspace loaded from ~/.RData]
Loading required package: RMySQL
Loading required package: DBI
>
> install.packages("XLConnect")
also installing the dependencies ‘XLConnectJars’, ‘rJava’
trying URL 'https://cran.rstudio.com/bin/macosx/el-capitan/contrib/3.5/XLConnectJars_0.2-15.tgz'
Content type 'application/x-gzip' length 14810717 bytes (14.1 MB)
==================================================
downloaded 14.1 MB
trying URL 'https://cran.rstudio.com/bin/macosx/el-capitan/contrib/3.5/rJava_0.9-10.tgz'
Content type 'application/x-gzip' length 735656 bytes (718 KB)
==================================================
downloaded 718 KB
trying URL 'https://cran.rstudio.com/bin/macosx/el-capitan/contrib/3.5/XLConnect_0.2-15.tgz'
Content type 'application/x-gzip' length 9796724 bytes (9.3 MB)
==================================================
downloaded 9.3 MB
The downloaded binary packages are in
/var/folders/nl/7dfp7f693yb87ntg7qd70s7c0000gn/T//RtmpfXlNpJ/downloaded_packages
> library("XLConnect", lib.loc="/Library/Frameworks/R.framework/Versions/3.5/Resources/library")
Loading required package: XLConnectJars
Error: package or namespace load failed for ‘XLConnectJars’:
.onLoad failed in loadNamespace() for 'rJava', details:
call: dyn.load(file, DLLpath = DLLpath, ...)
error: unable to load shared object '/Library/Frameworks/R.framework/Versions/3.5/Resources/library/rJava/libs/rJava.so':
dlopen(/Library/Frameworks/R.framework/Versions/3.5/Resources/library/rJava/libs/rJava.so, 6): Library not loaded: /Library/Java/JavaVirtualMachines/jdk-9.jdk/Contents/Home/lib/server/libjvm.dylib
Referenced from: /Library/Frameworks/R.framework/Versions/3.5/Resources/library/rJava/libs/rJava.so
Reason: image not found
Error: package ‘XLConnectJars’ could not be loaded
> library("XLConnectJars", lib.loc="/Library/Frameworks/R.framework/Versions/3.5/Resources/library")
Error: package or namespace load failed for ‘XLConnectJars’:
.onLoad failed in loadNamespace() for 'rJava', details:
call: dyn.load(file, DLLpath = DLLpath, ...)
error: unable to load shared object '/Library/Frameworks/R.framework/Versions/3.5/Resources/library/rJava/libs/rJava.so':
dlopen(/Library/Frameworks/R.framework/Versions/3.5/Resources/library/rJava/libs/rJava.so, 6): Library not loaded: /Library/Java/JavaVirtualMachines/jdk-9.jdk/Contents/Home/lib/server/libjvm.dylib
Referenced from: /Library/Frameworks/R.framework/Versions/3.5/Resources/library/rJava/libs/rJava.so
Reason: image not found
> install.packages("XLConnectJars")
trying URL 'https://cran.rstudio.com/bin/macosx/el-capitan/contrib/3.5/XLConnectJars_0.2-15.tgz'
Content type 'application/x-gzip' length 14810717 bytes (14.1 MB)
==================================================
downloaded 14.1 MB
The downloaded binary packages are in
/var/folders/nl/7dfp7f693yb87ntg7qd70s7c0000gn/T//RtmpfXlNpJ/downloaded_packages
> library("XLConnectJars", lib.loc="/Library/Frameworks/R.framework/Versions/3.5/Resources/library")
Error: package or namespace load failed for ‘XLConnectJars’:
.onLoad failed in loadNamespace() for 'rJava', details:
call: dyn.load(file, DLLpath = DLLpath, ...)
error: unable to load shared object '/Library/Frameworks/R.framework/Versions/3.5/Resources/library/rJava/libs/rJava.so':
dlopen(/Library/Frameworks/R.framework/Versions/3.5/Resources/library/rJava/libs/rJava.so, 6): Library not loaded: /Library/Java/JavaVirtualMachines/jdk-9.jdk/Contents/Home/lib/server/libjvm.dylib
Referenced from: /Library/Frameworks/R.framework/Versions/3.5/Resources/library/rJava/libs/rJava.so
Reason: image not found
> library("XLConnect", lib.loc="/Library/Frameworks/R.framework/Versions/3.5/Resources/library")
Loading required package: XLConnectJars
Error: package or namespace load failed for ‘XLConnectJars’:
.onLoad failed in loadNamespace() for 'rJava', details:
call: dyn.load(file, DLLpath = DLLpath, ...)
error: unable to load shared object '/Library/Frameworks/R.framework/Versions/3.5/Resources/library/rJava/libs/rJava.so':
dlopen(/Library/Frameworks/R.framework/Versions/3.5/Resources/library/rJava/libs/rJava.so, 6): Library not loaded: /Library/Java/JavaVirtualMachines/jdk-9.jdk/Contents/Home/lib/server/libjvm.dylib
Referenced from: /Library/Frameworks/R.framework/Versions/3.5/Resources/library/rJava/libs/rJava.so
Reason: image not found
Error: package ‘XLConnectJars’ could not be loaded
>
thanks for any help. I am very new and a little fragile and very shellshocked by nothing seeming to work
stephen