How to add each data frame created inside a loop to a separate sheet in excel?

Question

for(x in unique_seg){

bf <- data.frame(matrix(x,nrow =3,ncol =3))

write.xlsx(bf,'bf.xlsx', sheetname =x, append=True) }

But I see only last loop is returned. How to get all sheets in 1 excel ?

You are creating a matrix from a single value?. The append = TRUE should be correct rather than True — akrun
– akrun, Commented Dec 11, 2020 at 18:52
Package used is xlsx. Though the above is some random dataframe I created. I actually wanted to know how can I store each dataframe created inside a loop into an excel sheet — Jury Reta
– Jury Reta, Commented Dec 11, 2020 at 18:59

akrun · Accepted Answer · 2020-12-11 19:00:56Z

1

If we want to return the output, create a list and assign the output to the list

lst1 <- vector('list', length(unique_seg))
names(lst1) <- unique_seg    

for(x in unique_seg){

   bf <- data.frame(matrix(x,nrow =3,ncol =3))

  write.xlsx(bf,'bf.xlsx', sheetname =x, append=TRUE)
  lst1[[x]] <- bf
  }

answered Dec 11, 2020 at 19:00

akrun

891k38 gold badges590 silver badges700 bronze badges

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

Collectives™ on Stack Overflow

How to add each data frame created inside a loop to a separate sheet in excel?

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

Related