write_xlsx {do}

Write data to Excel file write or append one or more data into one Excel file in each sheet.

Description

Write data to Excel file write or append one or more data into one Excel file in each sheet.

Usage

write_xlsx(
  ...,
  file,
  sheet,
  col.names = TRUE,
  row.names = FALSE,
  overwrite = FALSE,
  append = FALSE
)

Arguments

...

one or more data

file

Excel file name

sheet

sheet names

col.names

logical, whether to write out column names

row.names

logical, whether to write out row names

overwrite

logical, whether to overwrite an existing file

append

logical, whether to add data to an existing file

Value

write one or more data into one Excel file

Examples

mtcars2 = mtcars
# write_xlsx(mtcars,mtcars2,file='mtcars')