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
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
List of major functions:
XLwriteOpento initiate/reset an export file
XLoneWayfor one-way contingency tables, with or without percent breakdown
XLtwoWay, the same for two-way tables (historically this was the first function)
XLunivariatefor summary statistics of continuous variables, potentially stratified by a categorical variable
XLregresSummaryfor standard 4-column regression output with confidence intervals and p-values, including transformations if desired
XLgenericto export any rectangular dataset
XLaddTextto add comments anywhere in the spreadsheet
XLtable1to 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