Can I write 2 different outputs in 2 different worksheets of the same excel workbook?

Ayushi_Aggarwal

I want to write various outputs in the same excel workbook. I tried giving different names to worksheets in the excel parameters but that didn't work.

Marco_Boeck

Hi,

Currently not natively supported, but coming with the next feature update, 9.3.

Regards,
Marco

varunm1

Hi @Ayushi_Aggarwal

As marco suggested, there is no built-in operator that writes into multiple sheets for now. There is a work around using python, you can see thin in below thread where @kayman provided an example. You can also download a paid extension (Advanced reporting) from the market place.

https://community.rapidminer.com/discussion/52794/wrinting-an-excel-file-with-multiple-sheets#latest

Thanks

Brian_Wells

I ran into the same problem last month.  Very excited that the capability will be added in the next version!  Thanks, guys!

Meanwhile, I am using the attached VBA code in Excel.  I just made a "master" sheet and dropped it into the directory with my single tab Excel outputs from RapidMiner and then execute the "Combine_All_Files" macro and, voila.

Just create an .XLSM or XLSB file, add a macro module, and paste the attached code in.  Should work like a charm.  I've been using it for weeks.

sgenzer

ok that's pretty cool @Brian_Wells. I'm giving you a community "boost" badge just for cleverness

Scott

Brian_Wells