Writing into multiple sheets in an Excel

varunm1

Hello,

Is it possible to write into multiple sheets in an excel?

I tried using the same excel file name but changed the sheet names in "Write excel" operator for different subprocess. This is not working as it is replacing the old excel file with the new sheet name.

Is there any other way I can write into multiple sheets using excel operator in RM?

Thank you

IngoRM

Hi @varunm1

Not with the regular Write Excel operator.  There are a couple of workarounds for this:

1. using a third-party extension (not free)
2. using an R script
3. using a Python script

They are discussed here with examples: https://community.rapidminer.com/discussion/45854/wrinting-an-excel-file-with-multiple-sheets#latest

Hope this helps,
Ingo

varunm1

Thanks, @IngoRM I did a workaround with joins into a single sheet. Our research can't afford a paid extension 

I somehow missed these workarounds already available on the community. They are useful.

sgenzer

@varunm1 you may wish to try pinging @land directly to see if Old World Consulting offers any discounts for researchers or others in education.

Scott

Marco_Boeck

Hi,

My team has estimated the effort of implementing this feature recently, so it's quite safe to say it will make its way into the product eventually.
No timeframe yet, so don't call me out after the next release and complain if it's not there yet, otherwise I will have to stop giving little sneak peeks here

Regards,
Marco

land

In general we are open to give discounts to academics. On the other hand, the extension costs not even 30 €. Even a discount of 60% would not really significantly reduce the amount, don't you think

Nice to see, that his might eventually becomes a standard feature.

varunm1

Thanks for the generous responses. I am pleased with RM and partners contribution to research and education by providing a free version. We try to do our best as well in making RM a more familiar platform in the research community (at least in my areas) by citations and presentations.

WASmith

Glad to see that RM is considering adding this functionality. We have had to implement some workarounds in Python. I have not done a lot of comparisons (for obvious reasons), but I think Python is able to write excel files much more quickly than RM.

Either way, this seems to be a good candidate for someone to create a building block that wraps a python and/or R short-term fix. I started to look into it today and one challenge will be being able to pass the building block an unknown number of example sets from RM.