ヾ過去式°ο° 发表于 2015-12-4 22:49 
R中有xlsx包
使用方式:library(xlsx) 
               workbook
这个方法也不行,错误如下。
> file <- system.file("tests", "test_import.xlsx", package = "xlsx")
> res <- read.xlsx(file, 1)  # read first sheet
Error: could not find function "read.xlsx"
> head(res)
Error in head(res) : object 'res' not found
> library(xlsx)
载入需要的程辑包:rJava
Error : loadNamespace()里算'rJava'时.onLoad失败了,详细内容:
  调用: fun(libname, pkgname)
  错误: JAVA_HOME cannot be determined from the Registry
Error: 无法载入程辑包‘rJava’
> file <- system.file("tests", "test_import.xlsx", package = "xlsx")
> res <- read.xlsx(file, 1)  # read first sheet
Error: could not find function "read.xlsx"
> head(res)
Error in head(res) : object 'res' not found
> library("xlsx", lib.loc="D:/Program Files/R/R-3.2.2/library")
载入需要的程辑包:rJava
Error : loadNamespace()里算'rJava'时.onLoad失败了,详细内容:
  调用: fun(libname, pkgname)
  错误: JAVA_HOME cannot be determined from the Registry
Error: 无法载入程辑包‘rJava’
> library("rJava", lib.loc="D:/Program Files/R/R-3.2.2/library")
Error : loadNamespace()里算'rJava'时.onLoad失败了,详细内容:
  调用: fun(libname, pkgname)
  错误: JAVA_HOME cannot be determined from the Registry
Error: ‘rJava’程辑包或名字空间载入失败,
> library(xlsx)
载入需要的程辑包:rJava
Error : loadNamespace()里算'rJava'时.onLoad失败了,详细内容:
  调用: fun(libname, pkgname)
  错误: JAVA_HOME cannot be determined from the Registry
Error: 无法载入程辑包‘rJava’
> file <- system.file("tests", "test_import.xlsx", package = "xlsx")
> ??read.csv
> getwd()