RapidMiner

Write excel

Contributor II

Write excel

Dear All,

Is it possible to write different work sheet in the same excel file with rapidminer?

Thank you,

Penoca

8 REPLIES
Community Manager

Re: Write excel

No, that functionality is not available.

Regards,
Thomas
LinkedIn: Thomas Ott
Blog: Neural Market Trends
RMStaff

Re: 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))
}

ss.PNG

 

 

Regular Contributor

Re: Write excel

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

 

Regular Contributor

Re: Write excel

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

 

Contributor II

Re: Write excel

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?Bildschirmfoto 2016-12-15 um 10.41.10.png

Regular Contributor

Re: Write excel

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.  

Elite

Re: Write excel

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...

Highlighted
Regular Contributor

Re: Write excel

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.rapidminer.com/UpdateServer/faces/product_details.xhtml?productId=rmx_adv_report...

http://community.rapidminer.com/t5/Community-Blog/Advanced-Reporting-Extension-published-by-Old-Worl...

 

2017-04-13 12_24_48-_new process_ – RapidMiner Studio Large 7.4.000 @ RMUS-CWARRINGTON.png