读取xlsx文件 java包_安装xlsx包来读取Excel的xlsx文件(包括rJava的安装)

hadley贡献的包redxl可以读xls和xlsx

library(readxl)

# 加载包readxl(hadley贡献)  读取表格文档

# 如果没有则安装 install.packages("readxl")

# 包readxl说明The readxl package makes it easy to get data out of Excel and into R. Compared

# to many of the existing packages (e.g. gdata, xlsx, xlsReadWrite) readxl has no external

# dependencies so it's easy to install and use on all operating systems.

# It is designed to work with tabular data stored in a single sheet.

# 另外一种安装，GitHub上有最新版本的，需要先装"devtools"

# install.packages("devtools")    ###build_github_devtools()

# library(devtools)    ### install_github("hadley/readxl")

## read_excel reads both xls and xlsx files

#  read_excel("my-old-spreadsheet.xls") #read_excel("my-new-spreadsheet.xlsx")

## Specify sheet with a number or name

#  read_excel("m