将xlsx与R jupyter笔记本一起使用

Question

我试图在Mac上的Jupyter笔记本电脑中安装和使用R中的xlsx lackage。

install.packages("xlsx") 

好像跑的还行但是

library("xlsx")

结果如下：

Error: package or namespace load failed for 'xlsx':
 .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.6/Resources/library/rJava/libs/rJava.so':
  dlopen(/Library/Frameworks/R.framework/Versions/3.6/Resources/library/rJava/libs/rJava.so, 6): Library not loaded: /Library/Java/JavaVirtualMachines/jdk-11.0.1.jdk/Contents/Home/lib/server/libjvm.dylib
  Referenced from: /Library/Frameworks/R.framework/Versions/3.6/Resources/library/rJava/libs/rJava.so
  Reason: image not found
Traceback:

1. library("xlsx")
2. tryCatch({
 .     attr(package, "LibPath") <- which.lib.loc
 .     ns <- loadNamespace(package, lib.loc)
 .     env <- attachNamespace(ns, pos = pos, deps, exclude, include.only)
 . }, error = function(e) {
 .     P <- if (!is.null(cc <- conditionCall(e))) 
 .         paste(" in", deparse(cc)[1L])
 .     else ""
 .     msg <- gettextf("package or namespace load failed for %s%s:\n %s", 
 .         sQuote(package), P, conditionMessage(e))
 .     if (logical.return) 
 .         message(paste("Error:", msg), domain = NA)
 .     else stop(msg, call. = FALSE, domain = NA)
 . })
3. tryCatchList(expr, classes, parentenv, handlers)
4. tryCatchOne(expr, names, parentenv, handlers[[1L]])
5. value[[3L]](cond)
6. stop(msg, call. = FALSE, domain = NA)

我尝试了sudo R CMD javareconf，结果是：

Java解释器： /usr/bin/javaJava版本：13.0.2Java主路径： /Library/Java /JavaVirtualMachines/adoptopenjdk-13-openj9.jdk/Contents/HomeJava编译器： /usr/bin/javacJava头生成： /usr/bin/javahJava归档工具： /usr/bin/jar

尝试编译和链接JNI程序检测到的JNI cpp标志：-I$（JAVA\u HOME）/include-I$（JAVA\u HOME）/include/darwin检测到的JNI链接器标志：-L$（JAVA\u HOME）/lib/default-ljvm clang-I”/库/框架/R.framework/资源/包括“-DNDEBUG-I/库/JAVA/JavaVirtualMachine/采用OpenJDK-13-openj9。jdk/Contents/Home/include-I/Library/Java/JavaVirtualMachines/adoptopenjdk-13-openj9。jdk/Contents/Home/include/darwin-isysroot/Library/Developer/CommandLineTools/sdk/MacOSX。sdk-I/usr/local/include-fPIC-Wall-g-O2-c conftest。c-o确认测试。o clang-dynamiclib-Wl，-headerpad\u max\u install\u names-未定义的dynamic\u lookup-single\u module-multiply\u defined suppress-L/Library/Frameworks/R.framework/Resources/lib-L/usr/local/lib-o conftest。所以请确认。o-L/库/Java/JavaVirtualMachine/采用OpenJDK-13-openj9。jdk/Contents/Home/lib/default-ljvm-F/Library/Frameworks/R.framework/-框架R-Wl，-框架-Wl，CoreFoundation

JAVA_HOME： /Library/Java /JavaVirtualMachines/adoptopenjdk-13-openj9.jdk/Contents/HomeJava库路径：$（JAVA_HOME）/lib/默认JNI cpp标志：-我$（JAVA_HOME）/包含-我$（JAVA_HOME）/包含/darwin JNI链接器标志：-L$（JAVA_HOME）/lib/默认-ljvm更新 /Library/Frameworks/R.framework/Resources中的Java配置完成。

我错过了什么？

Answer 1

库（readxl）

PDF格式

PDF格式