#安装加载readxl包
library(“readxl”)
#读取xlsx文件
file<-read_excel(“xxx.xlsx”)
#读取表sheet
read_excel(xlsx_example, sheet = "name") #约定约束范围读取
read_excel(xlsx_example, range = "C1:E4")
read_excel(xlsx_example, range = cell_rows(1:4)) read_excel(xlsx_example, range = cell_cols("B:D")) read_excel(xlsx_example, range = "mtcars!B1:D5")
read_excel(xlsx_example, na = "setosa")
如若转载,请注明出处:https://www.ouq.net/r%e8%af%bb%e5%8f%96excel%e7%9a%84xls%e5%92%8cxlsx%e6%a0%bc%e5%bc%8f%e6%96%87%e4%bb%b6.html