看到网上很多用R读取excel数据的问题,今天就根据本人成功实验的结果,特地把步骤分享出来:
一、加载包:
install.packages("xlsx")
Installing package into ‘/home/jiandong/R/i686-pc-linux-gnu-library/3.4’
(as ‘lib’ is unspecified)
also installing the dependency ‘xlsxjars’
* installing *source* package ‘xlsxjars’ ...
** 成功将‘xlsxjars’程序包解包并MD5和检查
** R
** inst
** preparing package for lazy loading
** help
*** installing help indices
** building package indices
** testing if installed package can be loaded
* DONE (xlsxjars)
* installing *source* package ‘xlsx’ ...
** 成功将‘xlsx’程序包解包并MD5和检查
** R
** inst
** preparing package for lazy loading
** help
*** installing help indices
** building package indices
** installing vignettes
** testing if installed package can be loaded
* DONE (xlsx)
The downloaded source packages are in
‘/tmp/RtmpjYbp3s/downloaded_packages’
看一下原始数据:
library("xlsx", lib.loc="~/R/i686-pc-linux-gnu-library/3.4")
载入需要的程辑包:rJava
载入需要的程辑包:xlsxjars
> read.xlsx('/home/jiandong/桌面/data.xlsx')
Error in read.xlsx("/home/jiandong/桌面/data.xlsx") :
Please provide a sheet name OR a sheet index.
报错:提示需要指定读入那个sheet的数据,那就修改代码如下:
install.packages("readxl")
结果如下:
Installing package into ‘/home/jiandong/R/i686-pc-linux-gnu-library/3.4’
(as ‘lib’ is unspecified)
试开URL’https://cloud.r-project.org/src/contrib/readxl_1.0.0.tar.gz'
Content type 'application/x-gzip' length 1936302 bytes (1.8 MB)
==================================================
downloaded 1.8 MB
报错了:
Warning in install.packages :
installation of package ‘cellranger’ had non-zero exit status
输入:
install.packages("cellranger")
部分结果显示如下:
** 成功将‘cellranger’程序包解包并MD5和检查
** R
** inst
** preparing package for lazy loading
** help
*** installing help indices
** building package indices
** installing vignettes
** testing if installed package can be loaded
* DONE (cellranger)
The downloaded source packages are in
‘/tmp/RtmpjYbp3s/downloaded_packages’
安装成功后,再次输入:
install.packages("readxl")
成功!
** inst
** preparing package for lazy loading
** help
*** installing help indices
** building package indices
** installing vignettes
** testing if installed package can be loaded
* DONE (readxl)
The downloaded source packages are in
‘/tmp/RtmpjYbp3s/downloaded_packages’