write_excel_allsheets {fabR}

Write all Excel sheets using writexl::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/

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)

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.

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

See Also

writexl::write_xlsx()

writexl::write_xlsx()

Examples

{

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

}

{

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

}