Maxim
1
Hello. I need to write 2 data tables on the same list in one Excel spreadsheet. I run the following code:
write.xlsx(c(VNINDEXlogreturns_train,VNINDEX_predictions_total), "VNINDEX_predictions.xlsx",sheetName = "Sheet1")
I'd like to get 2 data tables, separated by 1 or several columns on the same spreadsheet. But after running this code I don't get the desired result.
How can I solve this problem?
Thank you for your effort.
joels
2
I'm not sure what package you're using, but here's an option using the openxlsx
package. We'll write the built-in mtcars
and iris
data frames.
library(openxlsx)
wb = createWorkbook()
sht = addWorksheet(wb, "my sheet")
start.cols = c(1, ncol(mtcars) + 2)
walk2(list(mtcars, iris), start.cols,
~writeData(wb, sht, .x, startCol=.y))
saveWorkbook(wb, "test.xlsx")
Maxim
4
@joels When I run your code, I get the following error:
Error in walk2(list(mtcars, iris), start.cols, ~writeData(wb, sht, .x, :
could not find function "walk2"
What is walk2?
I use to exploit xlsx
package.
purrr library within tidyverse package contains many useful map and walk functions (including walk2)
Maxim
6
Thanks, after installing tidyverse
and purrr
code started working!
system
Closed
7
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
If you have a query related to it or one of the replies, start a new topic and refer back with a link.