XLConnect中的错误 [英] Error in XLConnect
问题描述
我正在尝试将Excel工作表导入r.我使用了以下代码:
I am trying to import an excel sheet into r. I used the following code:
x <- loadWorkbook("x.xlsx")
b <- readWorksheet(x, sheet="b")
第一行工作正常,但是运行第二行会出现以下错误:
The first line works fine, however, running the second gives the following error:
Error in (function (classes, fdef, mtable) :
unable to find an inherited method for function ‘readWorksheet’ for signature ‘"jobjRef", "character"’
该工作表中没有缺失的值.
I have no missing values in that sheet.
出于复制目的,请从 https://github.com/ahmedfsalhin/1stpaper 下载trial.xlsx
a>.
For the purpose of reproducing, download trial.xlsx
from https://github.com/ahmedfsalhin/1stpaper.
系统信息:优胜美地操作系统.
system info: Yosemite operating system.
推荐答案
看来,根本原因"是您应该添加代码以指定函数及其所属的软件包.在这种情况下,键入XLConnect::loadWorkbook
以选择所需的那个.在R
中没有混乱"或重复选择的函数名称.选择取决于所有已加载软件包的加载顺序.使用search()
查看为输入的命令检查软件包的顺序.
It appears the "root cause" is that you should add code to specify both the function and the package it belongs to. Type XLConnect::loadWorkbook
to select the one you want in this case. There's no 'confusion,' or random selection of duplicated function names in R
. The choice depends on the load order of all loaded packages. Use search()
to see the order in which packages are checked for the command you've entered.
例如,目前我得到
search()
[1] ".GlobalEnv" "package:caTools"
[3] "package:XLConnect" "package:XLConnectJars"
[5] "package:stats" "package:graphics"
[7] "package:datasets" "package:vecsets"
[9] "package:cgwtools" "package:grDevices"
[11] "package:utils" "package:methods"
[13] "Autoloads" "package:base"
您会注意到,首先选择了环境(.GlobalEnv
)中的所有内容,例如,所有已加载的库都覆盖了base
包.
You'll notice that anything in your environment (.GlobalEnv
) is selected first, and that all loaded libraries override the base
package, for example.
这篇关于XLConnect中的错误的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!