Rename excel sheets in R studio

Question

I have one spreadsheet with 4 sheets in it, and I want to rename the sheets when I export the file from R.

How can I do it- I can't download XLConnect library.

This is what I have so far:

sheets <- list(sheet1 = Top_Balances, sheet2 = Over_60, sheet3 = CI, sheet4 = CL)
write_xlsx(sheets, "C:/Users/Desktop/R/April Aging.xlsx")

Thanks!

Answer 1

Try this one, see here https://github.com/ropensci/writexl/issues/18

write_xlsx(list(sheet1 = Top_Balances, sheet2 = Over_60, sheet3 = CI, sheet4 = CL))