'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

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. https://github.com/carleshf/loadxls

Purpose

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

News

NEWS-xlsimple

#> Last Update: 2017-03-21 14:14:21

Version history.

Planned Updates

  • None at this time.

v0.0.1.0001

2017-03-21

  • Bug fixes and additional functionality added.

v0.0.1.0000

2017-03-16

  • Created package.

Reference manual

It appears you don't have a PDF plugin for this browser. You can click here to download the reference manual.

install.packages("xlsimple")

0.0.1 by Jon Harcum, 2 years ago


Browse source code at https://github.com/cran/xlsimple


Authors: Jon Harcum , Erik Leppo


Documentation:   PDF Manual  


GPL-3 license


Suggests XLConnect, knitr


See at CRAN