rSpliteExcel

The goal of rSpliteExcel is to split excel files to separate excel, or gather sheets with same form.

Installation

You can install the development version of rSpliteExcel from GitHub with:

# install.packages("devtools")
devtools::install_github("ChevyXu/rSpliteExcel")

Example

This is a basic example which shows you how to solve a common problem:

# library(rSpliteExcel)
## basic example code
rSpliteExcel::multiplesheets(fname = "example/test.xlsx")
#> [[1]]
#> [1] "column1" "column2" "column3"
#> 
#> [[2]]
#> [1] "column1"
#> 
#> [[3]]
#> [1] "column2"
#> 
#> [[4]]
#> [1] "column2"
#> 
#> [[5]]
#> [1] "column1" "column2" "column3"

# library(rSpliteExcel)
## basic example code
# wirte sheets with same form.
# rSpliteExcel::multiplesheets_write(fname = "example/test.xlsx")