Write all Excel sheets using writexl::write_xlsx() recursively

Source: R/00-utils.R, R/05-as_any.R

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/

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.

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()))

}