Write excel

To workaround the issue that ‘write Excel’ cannot append extra data frame to another sheet of an existing excel file. We can combine R scripts inside Rapidminer Studio to write multiple sheets with the xlsx package from R.

You just need to use a different sheetName for each data frame and you need to add append=TRUE, and this is the example code put inside 'Excetue R' operator

# rm_main is a mandatory function, 
# the number of arguments has to be the number of input ports (can be none)
rm_main = function(data)
{
#install.packages("xlsx")
dataframe2 <- data
library(xlsx)
write.xlsx(data, file="C:\\Users\\YuanyuanHuang\\Documents\\RMCommunity\\filename.xlsx", sheetName="sheet1")
write.xlsx(dataframe2, file="C:\\Users\\YuanyuanHuang\\Documents\\RMCommunity\\filename.xlsx", sheetName="sheet2", append=TRUE)
return(list(data))
}