R语言数据分析之一-《R语言下载及读取excel导入excel》

一、下载

https://mirrors.tuna.tsinghua.edu.cn/CRAN/
下载自己电脑版本对应的R

二、打开

点他

三、输入命令

install.packages('xlsx')

然后报错咯

报错信息

还安装相依关系‘rJava’, ‘xlsxjars’

试开URL’https://mirrors.bfsu.edu.cn/CRAN/bin/windows/contrib/4.1/rJava_1.0-6.zip'
Content type 'application/zip' length 1513770 bytes (1.4 MB)
downloaded 1.4 MB

试开URL’https://mirrors.bfsu.edu.cn/CRAN/bin/windows/contrib/4.1/xlsxjars_0.6.1.zip'
Content type 'application/zip' length 9485688 bytes (9.0 MB)
downloaded 9.0 MB

试开URL’https://mirrors.bfsu.edu.cn/CRAN/bin/windows/contrib/4.1/xlsx_0.6.5.zip'
Content type 'application/zip' length 375332 bytes (366 KB)
downloaded 366 KB

package ‘rJava’ successfully unpacked and MD5 sums checked
package ‘xlsxjars’ successfully unpacked and MD5 sums checked
package ‘xlsx’ successfully unpacked and MD5 sums checked

The downloaded binary packages are in
        C:\Users\wenxiaoyu_intern\AppData\Local\Temp\RtmpQT3KE0\downloaded_packages

解决方法：

install.packages("rJava")
install.packages("xlsxjars") 
install.packages("xlsx") 
library(xlsx)

然后又报错

错误: package or namespace load failed for ‘xlsx’:
 loadNamespace()里算'rJava'时.onLoad失败了，详细内容：
  调用: fun(libname, pkgname)
  错误: JAVA_HOME cannot be determined from the Registry

解决方法：
打开
https://www.oracle.com/java/technologies/downloads/#jdk18-windows

选择第二个

下载并且安装

然后再次输入

library(rJava)
library(xlsx)

就搞定咯

四、读取excel

ray=read.xlsx('C:/Users/wenxiaoyu_intern/Desktop/1.xlsx',1)
ray

读取完成