Skip to contents

It's useful for saving multiple data to a multiple sheets of a single Excel/Openoffice/libreoffice file.

Usage

write_xlsx(data, distfile, ...)

Arguments

data

A named list of tibbles

distfile

The name of the destination file.

...

Other parameters to openxls::write.xlsx function

Details

The write_xlsx it's a wroapper for openxls::write.xlsx.

Examples

l <- list("IRIS" = iris, "MTCATS" = mtcars, matrix(runif(1000), ncol = 5))
tmp_file <- tempfile(fileext = ".xlsx")
write_xlsx(l, tmp_file, colWidths = c(NA, "auto", "auto"))
file.remove(tmp_file)
#> [1] TRUE