目前发现R中最方便的excel文件读取方法为readxl包,首先按照R包:
install.packages(‘readxl’, repos = ‘https://mirrors.tuna.tsinghua.edu.cn/CRAN‘)
install.packages(‘rlang’, repos = ‘https://mirrors.tuna.tsinghua.edu.cn/CRAN‘)
读取excel文件:
library(readxl)
a <- read_excel('./result.xlsx', sheet=1, na='NA')