xlsx是Microsoft Office EXCEL 2007/2010/2013/2016/2019文档的扩展名。其基于Office Open XML标准的压缩文件格式取代了其以前专有的默认文件格式,在传统的文件名扩展名后面添加了字母“x”(即“.docx”取代“.doc”、“.xlsx”取代“.xls”、“.pptx”取代“.ppt”)。任何能够打开“.xlsx”文件的文字处理软件都可以将该文档转换为“.xls”文件,“.xlsx”文件比“.xls”文件所占用空间更小。
#install.packages("xlsx")
library(xlsx)
ls("package:xlsx")
### 读文件
sheet1_df = read.xlsx('test.xlsx',sheetIndex=1,startRow = 3) #从第三行开始读
sheet2_df = read.xlsx('test.xlsx',sheetIndex=2)
sheet3_df = read.xlsx('test.xlsx',sheetName = 'sheet3')
head(sheet3_df)
### 存储文件
write.xlsx(sheet1_df,"test11.xlsx",row.names = FALSE,
sheetName = "Sheet1")
write.xlsx(sheet2_df,"test11.xlsx",row.names = FALSE,
append = TRUE,,sheetName = "Sheet2")
write.xlsx(sheet3_df,"test11.xlsx",row.names = FALSE,
append = TRUE,,sheetName = "Sheet3")