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:
And the development version from GitHub with:
# install.packages("devtools") devtools::install_github("tetratech/xlsimple")
Functions in xlsimple
|addXLsheetStd||Add a sheet to the 'Excel' workbook|
|.findFile||Find Recent File Information|
|getXLsettings||Get Default 'Excel' cell styles|
|readXLworkbook||Load a full 'MS Excel' File|
|saveXLworkbook||Save 'Excel' Workbook to disk|
|.addXLreadme||Add a readme sheet to the 'Excel' workbook|
Last month downloads
|SystemRequirements||Java (>= 8, <= 11)|
|Packaged||2020-07-31 14:27:20 UTC; Erik.Leppo|
|Date/Publication||2020-08-01 00:50:03 UTC|
Include our badge in your README