Writing to Excel from R

R Packages Quick Tips

Spending your days R but working closely with analysts and leadership that live in Excel? Get familiar with openxlsx.

Javier Orraca (Scatter Podcast)
01-09-2020

openxlsx is an awesome package for writing multiple datasets to multiple sheets of an Excel workbook, and allows for robust styling and cell formatting. I found a tutorial on RPubs written by Ezekiel Adebayo Ogundepo covering this package that I often use at work. Definitely bookmark worthy.

Here is a high-level code example:

library(openxlsx)

# Name the Excel worksheets where you want to export data to
list_of_datasets <- list("Overall Summary" = df_1, "LOB Summary" = df_2, "Details" = df_3)

# Save the Excel workbook to your wd with your worksheet list and name the Excel file
write.xlsx(list_of_datasets, "Excel_Workbook_2017.01.20.xlsx")

Links:

Reuse

Text and figures are licensed under Creative Commons Attribution CC BY 4.0. The figures that have been reused from other sources don't fall under this license and can be recognized by a note in their caption: "Figure from ...".

Citation

For attribution, please cite this work as

Orraca (2020, Jan. 9). Javier Orraca: Writing to Excel from R. Retrieved from https://www.javierorraca.com/posts/2020-01-09-Writing-to-Excel-from-R/

BibTeX citation

@misc{orraca2020writing,
  author = {Orraca, Javier},
  title = {Javier Orraca: Writing to Excel from R},
  url = {https://www.javierorraca.com/posts/2020-01-09-Writing-to-Excel-from-R/},
  year = {2020}
}