Write Excel workbook — write_excel_workbook • wheretowork

Save a table to disk as an Excel Spreadsheet.

write_excel_workbook(x, path)

Arguments

x	`data.frame` object (or `list` of `data.frame` objects) to save to disk.
path	`character` file path to save data.

Value

Invisible TRUE indicating success.

Details

This function is similar to the openxlsx::write.xlsx function. The main difference is that it formats cells columns containing numeric values (and numeric-like values) using the "NUMBER" format, and the remaining cells as "TEXT" format.

Examples

# create file path to save data
f <- tempfile(fileext = ".xlsx")

# load example dataset to save to disk
data(iris)
d <- iris

# save dataset to disk
write_excel_workbook(d, f)