This is an R package to generate tabular summaries in formats commonly found in scientific articles, and export them to Office-compatible spreadsheet document (.xls/.xlsx).

It answers a need commonly encountered by

- analysts working with scientific investigators on academic publications;
- and generally, analysts needing to produce summaries for non-analyst audiences.

The package’s functions save tedious work in converting R output to “normal human” summary tables. They also help ensure reproducible data analysis. One can see this as an Office-compatible version of ‘xtable’.

The underlying functionality to open, write and manipulate
spreadsheets is provided by the `XLConnect`

package, which in
turn relies upon `rJava`

.

List of major functions:

`XLwriteOpen`

to initiate/reset an export file`XLoneWay`

for one-way contingency tables, with or without percent breakdown`XLtwoWay`

, the same for two-way tables*(historically this was the first function)*`XLunivariate`

for summary statistics of continuous variables, potentially stratified by a categorical variable`XLregresSummary`

for standard 4-column regression output with confidence intervals and p-values, including transformations if desired`XLgeneric`

to export any rectangular dataset`XLaddText`

to add comments anywhere in the spreadsheet**New for 0.4.0!**`XLtable1`

to export an omnibus battery of tables typically encountered in Table 1 of an article. All tables must be of the same type, from among one-way, two-way or continuous.

Also worthy of mention is `niceRound`

, a generally useful
utility that reports numbers rounded to the actual specified number of
digits, rather than annoyingly dropping digits if the number is “too
round”.

This package is available on GitHub (live copy) CRAN (periodic updates). If you get it from here, then when compiling the package, you might need to roxygenize to get all the help files.

Comments welcome, to assaf.oron at seattlechildrens.org