Provides a simple wrapper for some 'XLConnect' functions. 'XLConnect' is a package that allows for reading, writing, and manipulating 'Microsoft Excel' files. This package, 'xlsimple', adds some documentation and pre-defined formatting to the outputted 'Excel' file. Individual sheets can include a description on the first row to remind user what is in the data set. Auto filters and freeze rows are turned on. A brief readme file is created that provides a summary listing of the created sheets and, where provided, the description.
#> Last Update: 2020-07-31 09:07:59
Provides a simple wrapper for some ‘XLConnect’ functions. Individual sheets can include a description on the first row to remind user what is in the data set. Auto filters and freeze rows are turned on. A brief readme file is created that provides a summary listing of the created sheets and where provided the description.
Included one function, read_all(), from the package ‘loadxls’ by Carles Hernandez-Ferrer (carleshf). This was in a GitHub repository, but it does not exist as of 2020-07-20. The original blog post is below. https://carleshf87.wordpress.com/2016/01/24/loadxls-r-package/
To quickly read/write ‘Excel’ worksheet names to/from R. Includes some default options that make it easier on the user.
You can install the released version of ‘baytrends’ from CRAN with:
install.packages("xlsimple")
And the development version from GitHub with:
# install.packages("devtools")
devtools::install_github("tetratech/xlsimple")