Export multiple data frames to multiple Excel worksheets

Question

I'm trying to export multiple data frames into one excel file with multiple sheets.

This is the code I used:

setwd('C:/Users/Desktop/R')
library("readxl")
library("writexl")
AR <- read_excel("FEB_AR.xlsx",sheet="After sort")
library(plyr)
#Top 10
Top_10 = AR[order(AR$Amount, decreasing= T),]
Top_10 = Top_10[1:15,]
Top10 <- as.data.frame(Top_10)
#Top Over 60
Top_Over_60 = AR[order(AR$Total, decreasing= T),]
Top_Over_60 = Top_Over_60[1:15,]
TopOver60 <- as.data.frame(Top_Over_60)
sheets <- list("Top10" = sheet1, "TopOver60" = sheet2) 
write_xlsx(sheets, "C:/Users/Desktop/R")

This is the message I receive:

> sheets <- list("Top10" = sheet1, "TopOver60" = sheet2) 
Error: object 'sheet1' not found
> write_xlsx(sheets, "C:/Users/Adi.Koren/Desktop/R")
Error in is.data.frame(x) : object 'sheets' not found

Also, I can't use the packages 'openxlsx' or 'xlsx' because they require a java update which I can't download (it's a work computer).

Ronak Shah · Accepted Answer · 2021-03-25 11:33:03Z

2

Try the following :

sheets <- list(sheet1 = Top10, sheet2 = Top_Over_60) 
writexl::write_xlsx(sheets, "result.xlsx")

answered Mar 25, 2021 at 11:33

Ronak Shah

391k20 gold badges173 silver badges237 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Export multiple data frames to multiple Excel worksheets

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest