Go to TogaWare.com Home Page. Data Science Desktop Survival Guide
by Graham Williams
Duck Duck Go


Excel Data Write

20200922 An Excel spreadsheet can be written using writexl. 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()) %>%

See Section 6.4 for an example of using this created spreadsheet.

Support further development by purchasing the PDF version of the book.
Other online resources include the GNU/Linux Desktop Survival Guide.
Books available on Amazon include Data Mining with Rattle and Essentials of Data Science.
Popular open source software includes rattle and wajig.
Hosted by Togaware, a pioneer of free and open source software since 1984.
Copyright © 2000-2020 Togaware Pty Ltd. . Creative Commons ShareAlike V4.