Writing into multiple sheets in an Excel

varunm1
New Altair Community Member
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
0
Best Answer
-
Hi @varunm1Not with the regular Write Excel operator. There are a couple of workarounds for this:
- using a third-party extension (not free)
- using an R script
- using a Python script
They are discussed here with examples: https://community.rapidminer.com/discussion/52794/wrinting-an-excel-file-with-multiple-sheets#latestHope this helps,
Ingo1
Answers
-
Hi @varunm1Not with the regular Write Excel operator. There are a couple of workarounds for this:
- using a third-party extension (not free)
- using an R script
- using a Python script
They are discussed here with examples: https://community.rapidminer.com/discussion/52794/wrinting-an-excel-file-with-multiple-sheets#latestHope this helps,
Ingo1 -
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,
Marco3 -
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.
4 -
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.1
-
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.0