export2xls.Rd
This function takes the result of createTable
and exports the tables to Excel format (.xlsx or .xls).
export2xls(x, file, which.table="descr", nmax=TRUE, header.labels=c())
an object of class 'createTable'.
file where table in Excel format will be written.
character indicating which table is printed. Possible values are 'descr', 'avail' or 'both' (partial matching allowed), exporting descriptives by groups table, availability data table or both tables, respectively. In the latter case ('both'), two sheets are built, one for each table. Default value is 'descr'.
logical, indicating whether to show the number of subjects with at least one valid value across all row-variables. Default value is TRUE.
see the 'header.labels' argument from createTable
.
The way to compute the 'N' shown in the bivariate table header, controlled by 'nmax' argument, has been changed from previous versions (<1.3). In the older versions 'N' was computed as the maximum across the cells withing each column (group) from the 'available data' table ('avail').
if (FALSE) {
require(compareGroups)
data(regicor)
res <- compareGroups(sex ~. -id-todeath-death-tocv-cv, regicor)
export2xls(createTable(res, hide.no = 'n'), file=tempfile(fileext=".xlsx"))
}