misty (version 0.7.1)

write.xlsx: Write Excel File

Description

This function calls the write_xlsx() function in the writexl package by Jeroen Ooms to write an Excel file (.xlsx).

Usage

write.xlsx(x, file = "Excel_Data.xlsx", col.names = TRUE, format = FALSE,
           use.zip64 = FALSE, check = TRUE)

Arguments

x

a matrix, data frame or (named) list of matrices or data frames that will be written in the Excel file.

file

a character string naming a file with or without file extension '.xlsx', e.g., "My_Excle.xlsx" or "My_Excel".

col.names

logical: if TRUE, column names are written at the top of the Excel sheet.

format

logical: if TRUE, column names in the Excel file are centered and bold.

use.zip64

logical: if TRUE, zip64 to enable support for 4GB+ Excel files is used.

check

logical: if TRUE (default), argument specification is checked.

Author

Jeroen Ooms

Details

This function supports strings, numbers, booleans, and dates.

References

Jeroen O. (2021). writexl: Export Data Frames to Excel 'xlsx' Format. R package version 1.4.0. https://CRAN.R-project.org/package=writexl

See Also

read.xlsx, write.sav, write.dta, write.mplus

Examples

if (FALSE) {
# Example 1: Write Excel file (.xlsx)
write.xlsx(mtcars, file = "mtcars.xlsx")

# Example 2: Write Excel file with multiple sheets (.xlsx)
write.xlsx(list(cars = cars, mtcars = mtcars), file = "Excel_Sheets.xlsx")}