7.6 Excel Data Writing

20200922 An Excel spreadsheet can be written using writexl (Ooms 2024). The basic functionality of writexl::write_xlsx() is to write a data frame to the named spreadsheet file. If a list of data frames is provided, each data frame populates a separate named sheet for each data frame.

Using rattle::weatherAUS we will create a spreadsheet by splitting the data frame into separate data frames, one per location, as a list. For each location a new sheet (tab) is created.

library(writexl)         # Write Excel spreadsheets: write_xlsx()

weatherAUS %>%
  group_by(Location) %>%
  group_split() %>%
  set_names(weatherAUS$Location %>% unique() %>% sort()) %>%
  write_xlsx('weatherAUS.xlsx')

See Section @ref(ingestion:read_excel) for an example of using this created spreadsheet.

References

Ooms, Jeroen. 2024. Writexl: Export Data Frames to Excel Xlsx Format. https://ropensci.r-universe.dev/writexl.

---

Your donation will support ongoing availability and give you access to the PDF version of this book. Desktop Survival Guides include Data Science, GNU/Linux, and MLHub. Books available on Amazon include Data Mining with Rattle and Essentials of Data Science. Popular open source software includes rattle, wajig, and mlhub. Hosted by Togaware, a pioneer of free and open source software since 1984. Copyright © 1995-2022 Graham.Williams@togaware.com Creative Commons Attribution-ShareAlike 4.0