Writing into multiple sheets in an Excel
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
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
Sort by:
1 - 7 of
71
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
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
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. 

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.
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.
Sort by:
1 - 1 of
11
- using a third-party extension (not free)
- using an R script
- using a Python script
Hi @varunm1
Not with the regular Write Excel operator. There are a couple of workarounds for this:
They are discussed here with examples: https://community.rapidminer.com/discussion/52794/wrinting-an-excel-file-with-multiple-sheets#latest
Hope this helps,
Ingo
Ingo
Ingo