write_excel_allsheets {fabR}R Documentation

Write all Excel sheets using xlsx::write.xlsx() recursively

Description

The R objects are read and the values are placed in separated sheets. This function is inspired by the function proposed in https://statmethods.wordpress.com/2014/06/19/quickly-export-multiple-r-objects-to-an-excel-workbook/

Usage

write_excel_allsheets(list, filename)

Arguments

list

R objects, coma separated.

filename

A character string of the path of the Excel file.

Value

Nothing to be returned. The file is created at the path declared in the environment.

See Also

xlsx::write.xlsx()

Examples

{

unlink(
  write_excel_allsheets(
    list = list(iris = iris, mtcars = mtcars),
    filename = tempfile()))

}


[Package fabR version 1.1.1 Index]