Write excel
Dear All,
Is it possible to write different work sheet in the same excel file with rapidminer?
Thank you,
Penoca
Find more posts tagged with
Altair EmployeeTo 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))
}
Here are a couple links to help you manipulate your excel logic...
(Terms to be aware of….Column = attribute, Row = Example, Function = Operator)
Here are a couple links to help you manipulate your excel logic...
(Terms to be aware of….Column = attribute, Row = Example, Function = Operator)
Hi,
I want to check about 380 texts. Yesterday I did it without "write excel" and everythink works till the point of using excel.
Today I tried it with write Excel but the software told me, that it´s too much Data. Do I really need a update?
It appears as though you hit the row limit on the free version.
I recommend you upgrade your license to get commerical versions or apply for an academic license.
An alternative would be to store all the texts as single entries in a repository first, then loop and add it to a csv file using the 'append to file'. This way your examples are added file by file instead of all at once and you don't reach the example limit. You can than open the csv in excell and save it as xslx.
But of course having a licensed version would be the more flexibe option...
A nice alternative has been built by Sebastian Land at OWC.
For example, with the write function, you can now write to a specific sheet.
No, that functionality is not available.