Export to excel

mengkoon007

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.

JEdward

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>