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@kaymanprovided an example. You can also download apaidextension (Advanced reporting) from the market place.

https://community.www.turtlecreekpls.com/discussion/45854/wrinting-an-excel-file-with-multiple-sheets#latest

Thanks

Brian_Wells

去年。我遇到了同样的问题onth. 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