🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

Export to excel

User: "mengkoon007"
New Altair Community Member
Updated by Jocelyn

Hi,

 

I have posted a process to the website and it is shown in table format.

 

I would like to allow end-user to be able to login and download the report to excel. 

 

Can someone kindly advice how can i go about doing? Thanks.

Find more posts tagged with

Sort by:
1 - 1 of 11
    User: "JEdward"
    New Altair Community Member

    Hello @mengkoon007,

     

    It's really simple.  Create a process that reads the data you are displaying as a table and use the Write Excel operator to write it into binary format.  Take this output (the purple line in the process below) and use this as the result port. 

     

    Next create a visualisation in your RapidMiner Server WebApp and select Binary as the output format. 

    Give it a nice name for the downloaded file in the options (for example myExcel.xlsx)

     

    You can use RawHTML in place of the text (where it says "Download" in the component options) and you'll be able to change it into a button pretty easily. 

     

    <?xml version="1.0" encoding="UTF-8"?><process version="7.3.000">
    <context>
    <input/>
    <output/>
    <macros/>
    </context>
    <operator activated="true" class="process" compatibility="7.3.000" expanded="true" name="Process">
    <process expanded="true">
    <operator activated="true" class="recall_from_app" compatibility="7.3.000" expanded="true" height="82" name="Recall from App" width="90" x="112" y="136">
    <parameter key="name" value="myTableData"/>
    </operator>
    <operator activated="true" class="write_excel" compatibility="7.3.000" expanded="true" height="82" name="Write Excel" width="90" x="447" y="136"/>
    <connect from_op="Recall from App" from_port="result" to_op="Write Excel" to_port="input"/>
    <connect from_op="Write Excel" from_port="file" to_port="result 1"/>
    <portSpacing port="source_input 1" spacing="0"/>
    <portSpacing port="sink_result 1" spacing="0"/>
    <portSpacing port="sink_result 2" spacing="0"/>
    </process>
    </operator>
    </process>