xlsimple v1.0.5

0

Monthly downloads

0th

Percentile

'XLConnect' Wrapper

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.

Readme

‘xlsimple’

#> 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/

Purpose

To quickly read/write ‘Excel’ worksheet names to/from R. Includes some default options that make it easier on the user.

Installation

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")

Functions in xlsimple

Name Description
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
No Results!

Last month downloads

Details

Type Package
Date 2020-07-30
SystemRequirements Java (>= 8, <= 11)
License GPL-3
Encoding UTF-8
LazyData TRUE
RoxygenNote 7.1.1
NeedsCompilation no
Packaged 2020-07-31 14:27:20 UTC; Erik.Leppo
Repository CRAN
Date/Publication 2020-08-01 00:50:03 UTC
suggests knitr
depends R (>= 3.2.0)
imports XLConnect
Contributors Jon Harcum

Include our badge in your README

[![Rdoc](http://www.rdocumentation.org/badges/version/xlsimple)](http://www.rdocumentation.org/packages/xlsimple)