compareGroups (version 3.3)

export2xls: Exporting descriptives table to Exel format (.xlsx or .xls)

Description

This function takes the result of createTable and exports the tables to Excel format (.xlsx or .xls).

Usage

export2xls(x, file, which.table="descr", nmax=TRUE, header.labels=c(), ...)

Arguments

x

an object of class 'createTable'.

file

file where table in HTML format will be written. Also, another file with the extension '_appendix' is written with the available data table. If missing, the HTML code is returned.

which.table

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. Default value is 'descr'.

nmax

logical, indicating whether to show the number of subjects with at least one valid value across all row-variables. Default value is TRUE.

header.labels

see the 'header.labels' argument from createTable.

…

arguments passed to write.xlsx function.

See Also

createTable, export2latex, export2pdf, export2csv, export2md, export2word

Examples

# NOT RUN {
# }
# NOT RUN {
require(compareGroups)
data(regicor)
res <- compareGroups(sex ~. -id-todeath-death-tocv-cv, regicor)
export2xls(createTable(res, hide.no = 'n'), file="table1.xlsx")
# }
# NOT RUN {
# }