I would like to export 100 data frames to an excel sheet and for this I thought I would create a list contening all the data frames and then use write_xlsx to export it. When I run the following code I get this error message : "Argument x must be a data frame or list of data frames".
Would any one know what the issue seems to be ?
Thanks!
df_list <- list()[sapply(ls(), function(x) any(is.data.frame(get(x))))]
writexl::write_xlsx(df_list, "M:")