Load library

We will first load the dplyr library:

library(dplyr)

Data sets

For the data frames, we will use datasets available from the dplyr package.

Here are the datasets available in dplyr:

However, for this, we will focus only just four of them:

band_instruments (3 rows and 2 columns)

band_members (3 rows and 2 columns)

star_wars (87 rows and 14 columns)

storms (19,066 rows and 13 columns)

Export (writexl)

I will demonstrate two methods for exporting to an Excel file: using the writexl and openxlsx packages

• Using writexl package
  • First, define the data frames within a list.
  • Export using write_xlsx

library(writexl)

excel_list <- list("Instruments" = band_instruments,
                   "Members" = band_members,
                   "Star Wars" = starwars,
                   "Storms" = storms)


write_xlsx(excel_list, "file_with_sheets_version1.xlsx")

If you prefer not to format the header (no bold header), you may include format_headers = FALSE:

write_xlsx(excel_list, "file_with_sheets_version1.xlsx", format_headers = FALSE)

Export (openxlsx)

• Using openxlsx package

  • Follow the same process: define the list.
  • Export using write.xlsx

library(openxlsx)

write.xlsx(excel_list, "file_with_sheets_version2.xlsx")

And there you have it! Now you can send the file to stakeholders who prefer Excel.