R语言中有很多读取Excel文件的Package,如RODBC、xlsx、gdata、xlsReadWrite等,但都有很多缺点(依赖Java,依赖操作系统,列数限制、效率等等),而下面要介绍的两个包可以完美地解决这些问题。
知识点 openxlsx: simplifies the the process of writing and styling Excel xlsx files from R and removes the dependency on Java. readxl: Read Excel Files. Works on Windows, Mac and Linux without external dependencies. 包安装install.packages("openxlsx")install.packages("readxl")
Read Excel file # readxl 自带的excel文件xls_file <- readxl::readxl_example("datasets.xls")xlsx_file <- readxl::readxl_example("datasets.xlsx")readxl::read_xls(xls_file)readxl::read_xlsx(xlsx_file)openxlsx::read.xlsx(xlsx_file)
Write Excel file xlsx_file <- readxl::readxl_example("datasets.xlsx")df <- openxlsx::read.xlsx(xlsx_file)openxlsx::write.xlsx(df, file = "datasets.xlsx")
Edit Excel file openxlsx 具有以下功能:
操作 WorkSheet 操作 Cell & Style 插入图片 函数 设置行高、列宽 格式化等等 Reference https://ycphs.github.io/openxlsx/index.html https://readxl.tidyverse.org/