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!