XLConnect: easy and controlled interface to Microsoft Excel
MS Excel is probably the most used support to share data analysis and reports in enterprise. Despite its popularity, performing data analysis within an Excel workbook can be cumbersome as well as error prone due to irreproducibility. A possible way out is to perform most of the steps of your data analysis and reporting in another programming language, such as R, and just present and share the results in Excel.
Using the package
XLConnect will allow you to read, write and manipulate MS Excel files from within R.
XLConnect’s main features:
read & write Excel worksheets & named regions
create, remove, rename, clone & hide / unhide worksheets
specify / apply cell styles, column width & row height
define behavior when error cells are encountered
force formula recalculation when workbooks are opened
others: merge / unmerge cells, set auto-filters