Save Excel Workbook with Multiple Sheets

[josh1400]

I would like to save several data sets as multiple sheets within one Excel workbook.

Currently, I read specific sheets in an Excel workbook and make updates to the data within Radiant.
I then save those updated data sets as csv files and manually copy and paste that data into the right sheet of the Excel workbook. I could copy from Radiant to save some steps, but I keep the csv files as history.

I could also write the data sets into SQL tables and connect each sheet of the Excel workbook to the correct table and always have a connection to the updated data. However, that's a little too intensive for temporary processes.

Ideally, there's an R function that I just can't find. If that doesn't exist, Radiant would be great if I could select multiple data sets and save them to an Excel workbook in the data>manage section.

[vnijs]

I'll think about that. In the meantime you can use something like the below in Report > Rmd. FYI iris and mtcars are default datasets that are always available in R

library(writexl)
write_xlsx(list(sheet1 = iris, sheet2 = mtcars), path = "~/Desktop/file_with_sheets.xlsx")

[josh1400]

That solves my issue! :)