Write excel

Pennoca

Dear All,

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

Thank you,

Penoca

Thomas_Ott

No, that functionality is not available.

yyhuang

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

 

 

CraigBostonUSA

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

 

CraigBostonUSA

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

 

fabian_preis

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?

CraigBostonUSA

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.  

kayman

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

CraigBostonUSA

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_reporting 

http://community.rapidminer.com/t5/Community-Blog/Advanced-Reporting-Extension-published-by-Old-World-Computing/ba-p/37451