Wrinting an excel file with multiple sheets

mandeep_kumarmandeep_kumar MemberPosts:2Contributor I
edited December 2018 inHelp

Hi

I'm looking for an option to write an excel/csv file with multiple sheets in it. The current "Write Excel" operator in Rapidminer can only write to a single sheet (under sheet name).

Is it possible to merge 2 excel files with different tab names into 1 file containing data from all tabs (across files) in Append mode ?

Thanks

Mandeep

Tagged:

Answers

  • sgenzersgenzer Administrator, Moderator, Employee, RapidMiner Certified Analyst, Community Manager, Member, University Professor, PM ModeratorPosts:2,959Community Manager

    hello@mandeep_kumar- welcome to the community. There are several threads on this topic including one exactly about this two weeks ago. Did you do a search?:)

    https://community.www.turtlecreekpls.com/t5/forums/searchpage/tab/message?advanced=false&allow_punctuation=false&q=excel%20multiple%20sheets

    Scott

  • mandeep_kumarmandeep_kumar MemberPosts:2Contributor I

    @sgenzer

    I have gone through these threads and i don't think there is any option except to have Execute R/python script that can perform.

    Do you know if there are any operators (in rapidminer) that can write data in multiple sheets in a single excel file.

    thanks

    Mandeep

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

    Hi@mandeep_kumar,

    To perform this task, you will need ofAdvanced Reporting Extension(to download and install from the MarketPlace).

    Here a process, where 2 exampleSets are written in two differents sheets of a same Excel file.

    < ?xml version = " 1.0 " encoding = " utf - 8 " ?> <过程版本sion="8.0.001">





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














    <参数键=“target_file”值= " C: \ \ Lione用户l\Documents\Formations_DataScience\Rapidminer\Tests_Rapidminer\Test_export_Excel_Extension\RM_Export_Excel.xlsx"/>









    < portSpacing端口= " source_input 2”间隔= " 0 " / >





















    NB : You have to create preliminarily in the Excel file, the sheets in which you want to write.

    I hope this help,

    Regards,

    Lionel

    sgenzer
  • Brian_WellsBrian_Wells MemberPosts:6Contributor II
    So it appears that this is still a shortcoming even in RM 9.2 and I have to say that I am stunned by such a glaring omission in the base feature set. If I did not love RapidMiner Studio so much I probably wouldn't care but simply use Alteryx or some other tool when I need to do large scale data reporting. Given how common the format is, how much it is used throughout most companies and the fact that there is no reasonable alternative format to Excel's collection of tabular data tables within a single file, this should be#1on the feature enhancement list with no close second. Having to purchase a third party extension to do this, even if the fee is nominal, is completely unacceptable for a piece of software that I pay $10,000/yr for, as is having to create my own operator using R or Apache POI, Python, etc.

    Please address this soon, guys. I am fighting for wide-spread RapidMiner adoption in my company and I can guarantee that this will be a major stumbling block for a lot of folks.
    varunm1 sgenzer CraigBostonUSA
  • kaymankayman MemberPosts:662Unicorn
    edited March 2019
    If you don't mind using python this can be easily be achieved using the xlsxwriter package.
    I share you point that having it out of the box available would be a great thing, but till then this may help also.

    Find attached a working sample writing different datasets to different tabs

    < ?xml version = " 1.0 " encoding = " utf - 8 " ?> <过程版本sion="9.1.000">


  • sgenzersgenzer Administrator, Moderator, Employee, RapidMiner Certified Analyst, Community Manager, Member, University Professor, PM ModeratorPosts:2,959Community Manager
    stay tuned@Brian_Wells :wink:
Sign InorRegisterto comment.