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)) }
另一个是存储所有的文本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...
0
CraigBostonUSAAdministrator, Employee, MemberPosts:34RM Team Member
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.
Contributor I
Answers
No, that functionality is not available.
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
Here are a couple links to help you manipulate your excel logic...
(Terms to be aware of….Column = attribute, Row = Example, Function = Operator)
Creating Macros Video
Merge Data Sources
Writing Excel Functions
Adjust Excel Headers
Remove Columns
Here are a couple links to help you manipulate your excel logic...
(Terms to be aware of….Column = attribute, Row = Example, Function = Operator)
Creating Macros Video
Merge Data Sources
Writing Excel Functions
Adjust Excel Headers
Remove Columns
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.
另一个是存储所有的文本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.
https://marketplace.www.turtlecreekpls.com/UpdateServer/faces/product_details.xhtml?productId=rmx_adv_reporting
http://community.www.turtlecreekpls.com/t5/Community-Blog/Advanced-Reporting-Extension-published-by-Old-World-Computing/ba-p/37451