fabR (version 2.1.0)

write_excel_allsheets: 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)

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.

Arguments

list

R objects, coma separated.

filename

A character string of the path of the Excel file.

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

}