"Export Excel with multiple sheets"

swasswas MemberPosts:2Learner I
edited June 2019 inHelp

Hello,

i can't find a solution for my problem. So i hope you guys could help me.

I'm creating two (or more) different results with rapidminer and i'd like them to write into one excel file in different sheets.

I'd really appreciate a hint how i could achieve this.

Kind regards,

swas

Edit:

I'm currently experimenting with macros and loops. But i'm unsure if that's the right way to do it.

I'd be also curious if it's possible to get the name of an retrieved dataset.

Tagged:

Answers

  • Telcontar120Telcontar120 Moderator, RapidMiner Certified Analyst, RapidMiner Certified Expert, MemberPosts:1,635Unicorn

    The Advanced Reporting Extension, which is available in the marketplace, allows you to do this. It is a paid extension but the cost is very reasonable. If there is a way to do it with the basic RapidMiner operators, I don't know how.

    Brian T.
    Lindon Ventures
    Data Science Consulting from Certified RapidMiner Experts
  • sgenzersgenzer Administrator, Moderator, Employee, RapidMiner Certified Analyst, Community Manager, Member, University Professor, PM ModeratorPosts:2,959Community Manager

    hi@swas- so@Telcontar120is correct. It should be easy but it's just not possible with the current tools. If you're really adventurous, you can see how I unzipped an XLSX file to do the opposite of what you're asking to get sheet names; it should work for your purposes:https://community.www.turtlecreekpls.com/t5/RapidMiner-Studio-Forum/Extract-Sheet-name-from-an-Excel-file/td-p/44747

    Scott

  • lionelderkrikorlionelderkrikor Moderator, RapidMiner Certified Analyst, MemberPosts:1,195Unicorn

    Hi again@swas,

    Here a process where each exampleset is copied in a different excel file using theWrite Exceloperator.

    It's not exactly what you want, but you can in Excel right click on a sheet and select export and then export the sheet to the excel file

    where you want to store all your example sets.

    Here the process :







    <运营商激活= " true " class = "过程”兼容ibility="8.0.001" expanded="true" name="Process">
























    <操作符=“false”class = " rmx_adv_reporti激活ng:open_report_excel" compatibility="2.1.693" expanded="true" height="103" name="Open Report (2)" width="90" x="447" y="187">





















































    NB : I try to do the same thing and "to tinker" with theAdvanced Reporting Extension(the free features), but in fine

    RapidMiner raise an error or only the last excel file is created (the precedent are crushed).

    I hope this process (to adapt to your own project) will help you despite all.

    Regards,

    Lionel

    sgenzer
  • SGolbertSGolbert RapidMiner Certified Analyst, MemberPosts:344Unicorn

    One option would be to save multiple CSV files, and then combine them directly with excel. There are some macros going around that are fit for the task, take a look at:

    https://stackoverflow.com/questions/12162477/importing-multiple-csv-to-multiple-worksheet-in-a-single-workbook

    There also some plugins for Excel that can do it, but I don't know if they are free or not.

    sgenzer
  • lionelderkrikorlionelderkrikor Moderator, RapidMiner Certified Analyst, MemberPosts:1,195Unicorn

    Hi@swas,

    @SGolbertinspire me a solution to automatically import the sheets of the created Excel files by RapidMiner (process I share above) in one single Excel file :

    You can download this Excel file with macros by clicking on the following link :

    https://drive.google.com/file/d/1W5gLA2J3xUh8W-sTMxN5KXgt1kZDez5g/view?usp=sharing

    1. You have first to select the path where your Excel files have been saved.

    Warning : All you excel file(s) have to be stored in the same path(which is normally the case after running the RapidMiner process) andno other Excel file(s) should be stored in this path.

    2. You click on the 'Import Excel sheets' button

    3. Normally, the sheets of the saved Excel file(s) are imported in the Excel file.

    Regards,

    Lionel

    NB : We're getting away from RapidMiner but it's for a good cause

Sign InorRegisterto comment.